eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_PRE_TAX_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 37: l_effective_date pay_payroll_actions.effective_date%TYPE;

33: p_retcode OUT NOCOPY VARCHAR2,
34: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
35: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE )
36: IS
37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
40: l_assact_action_status pay_assignment_actions.action_status%TYPE;
41: l_date_earned pay_payroll_actions.date_earned%TYPE;

Line 39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;

35: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE )
36: IS
37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
40: l_assact_action_status pay_assignment_actions.action_status%TYPE;
41: l_date_earned pay_payroll_actions.date_earned%TYPE;
42: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
43:

Line 41: l_date_earned pay_payroll_actions.date_earned%TYPE;

37: l_effective_date pay_payroll_actions.effective_date%TYPE;
38: l_value pay_jp_custom_pkg.value_rec;
39: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
40: l_assact_action_status pay_assignment_actions.action_status%TYPE;
41: l_date_earned pay_payroll_actions.date_earned%TYPE;
42: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
43:
44: ----------------------------------------
45: -- Cursor

Line 53: from pay_payroll_actions ppa,

49: paa.action_status ASSACT_ACTION_STATUS,
50: ppa.date_earned,
51: ppa.effective_date,
52: paa.assignment_id
53: from pay_payroll_actions ppa,
54: pay_assignment_actions paa
55: where paa.assignment_action_id=p_locked_assignment_action_id
56: and paa.action_status='C'
57: and ppa.payroll_action_id=paa.payroll_action_id

Line 65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,

61: PROCEDURE get_assignment_details(
62: p_errbuf OUT NOCOPY VARCHAR2,
63: p_retcode OUT NOCOPY VARCHAR2,
64: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
65: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
66: p_person_id OUT NOCOPY per_all_assignments_f.person_id%TYPE,
67: p_period_of_service_id OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE,
68: p_date_start OUT NOCOPY per_periods_of_service.date_start%TYPE,
69: p_leaving_reason OUT NOCOPY per_periods_of_service.leaving_reason%TYPE,

Line 113: p_effective_date IN pay_payroll_actions.effective_date%TYPE,

109: p_retcode OUT NOCOPY VARCHAR2,
110: p_locked_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
111: p_locking_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE,
112: p_assignment_id IN pay_assignment_actions.assignment_id%TYPE,
113: p_effective_date IN pay_payroll_actions.effective_date%TYPE,
114: p_value IN pay_jp_custom_pkg.value_rec)
115: IS
116: l_action_status VARCHAR2(1);
117: l_message VARCHAR2(255);

Line 320: p_business_group_id IN pay_payroll_actions.business_group_id%TYPE,

316: PROCEDURE ROLLBACK_ASSACT(
317: -----------------------------------------------------------------------
318: p_errbuf OUT NOCOPY VARCHAR2,
319: p_retcode OUT NOCOPY VARCHAR2,
320: p_business_group_id IN pay_payroll_actions.business_group_id%TYPE,
321: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE,
322: p_from_date IN DATE,
323: p_to_date IN DATE) IS
324: --

Line 328: FROM pay_payroll_actions ppa, pay_assignment_actions paa,

324: --
325:
326: CURSOR csr_assact IS
327: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
328: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
329: pay_payroll_actions ppa1, pay_assignment_actions paa1,
330: pay_action_information pai
331: WHERE ppa.business_group_id = p_business_group_id
332: AND ppa.payroll_id = p_payroll_id

Line 329: pay_payroll_actions ppa1, pay_assignment_actions paa1,

325:
326: CURSOR csr_assact IS
327: SELECT DISTINCT paa1.assignment_action_id, ppa1.payroll_action_id
328: FROM pay_payroll_actions ppa, pay_assignment_actions paa,
329: pay_payroll_actions ppa1, pay_assignment_actions paa1,
330: pay_action_information pai
331: WHERE ppa.business_group_id = p_business_group_id
332: AND ppa.payroll_id = p_payroll_id
333: AND ppa.date_earned BETWEEN p_from_date AND p_to_date

Line 344: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,

340: AND ppa1.business_group_id = p_business_group_id
341: AND ppa1.action_type = 'X';
342:
343: TYPE t_assact_rec IS RECORD(
344: payroll_action_id pay_payroll_actions.payroll_action_id%TYPE,
345: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE);
346:
347: TYPE t_assact_tab IS TABLE OF t_assact_rec INDEX BY BINARY_INTEGER;
348:

Line 351: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;

347: TYPE t_assact_tab IS TABLE OF t_assact_rec INDEX BY BINARY_INTEGER;
348:
349: l_assact_tab t_assact_tab;
350:
351: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
352: l_index NUMBER := 1;
353: l_count NUMBER;
354:
355: BEGIN