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_FI_ARCHIVE_PYSA dependencies on PAY_PAYROLL_ACTIONS

Line 49: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;

45: p_parameter_string IN VARCHAR2
46: ,p_token IN VARCHAR2
47: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
48: IS
49: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
50: l_start_pos NUMBER;
51: l_delimiter VARCHAR2(1):=' ';
52: l_proc VARCHAR2(40):= g_package||' get parameter ';
53: BEGIN

Line 102: FROM pay_payroll_actions

98: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'START_DATE')
99: ,PAY_FI_ARCHIVE_PYSA.GET_PARAMETER(legislative_parameters,'END_DATE')
100: ,effective_date
101: ,business_group_id
102: FROM pay_payroll_actions
103: WHERE payroll_action_id = p_payroll_action_id;
104: l_proc VARCHAR2(240):= g_package||' GET_ALL_PARAMETERS ';
105: --
106: BEGIN

Line 159: ,pay_payroll_actions ppa

155: ptp.start_date start_date,
156: ptp.period_name period_name,
157: ppf.payroll_name payroll_name
158: FROM per_time_periods ptp
159: ,pay_payroll_actions ppa
160: ,pay_payrolls_f ppf
161: WHERE ptp.payroll_id = ppa.payroll_id
162: AND ppa.payroll_action_id = p_run_payact_id
163: AND ppa.payroll_id = ppf.payroll_id

Line 335: ,pay_payroll_actions ppa

331: END LOOP;
332: CLOSE csr_get_element;
333: p_sql := 'SELECT DISTINCT person_id
334: FROM per_people_f ppf
335: ,pay_payroll_actions ppa
336: WHERE ppa.payroll_action_id = :payroll_action_id
337: AND ppa.business_group_id = ppf.business_group_id
338: ORDER BY ppf.person_id';
339: IF g_debug THEN

Line 365: FROM pay_payroll_actions ppa,

361: IS
362: SELECT act.assignment_id assignment_id,
363: act.assignment_action_id run_action_id,
364: act1.assignment_action_id prepaid_action_id
365: FROM pay_payroll_actions ppa,
366: pay_payroll_actions appa,
367: pay_payroll_actions appa2,
368: pay_assignment_actions act,
369: pay_assignment_actions act1,

Line 366: pay_payroll_actions appa,

362: SELECT act.assignment_id assignment_id,
363: act.assignment_action_id run_action_id,
364: act1.assignment_action_id prepaid_action_id
365: FROM pay_payroll_actions ppa,
366: pay_payroll_actions appa,
367: pay_payroll_actions appa2,
368: pay_assignment_actions act,
369: pay_assignment_actions act1,
370: pay_action_interlocks pai,

Line 367: pay_payroll_actions appa2,

363: act.assignment_action_id run_action_id,
364: act1.assignment_action_id prepaid_action_id
365: FROM pay_payroll_actions ppa,
366: pay_payroll_actions appa,
367: pay_payroll_actions appa2,
368: pay_assignment_actions act,
369: pay_assignment_actions act1,
370: pay_action_interlocks pai,
371: per_all_assignments_f as1

Line 398: pay_payroll_actions appa3

394: AND (as1.payroll_id = p_payroll_id OR p_payroll_id IS NULL)
395: AND NOT EXISTS (SELECT /* + ORDERED */ NULL
396: FROM pay_action_interlocks pai1,
397: pay_assignment_actions act2,
398: pay_payroll_actions appa3
399: WHERE pai1.locked_action_id = act.assignment_action_id
400: AND act2.assignment_action_id= pai1.locking_action_id
401: AND act2.payroll_action_id = appa3.payroll_action_id
402: AND appa3.action_type = 'X'

Line 408: pay_payroll_actions appa3

404: AND appa3.report_type = 'FI_ARCHIVE')
405: AND NOT EXISTS ( SELECT /* + ORDERED */ NULL
406: FROM pay_action_interlocks pai1,
407: pay_assignment_actions act2,
408: pay_payroll_actions appa3
409: WHERE pai1.locked_action_id = act.assignment_action_id
410: AND act2.assignment_action_id= pai1.locking_action_id
411: AND act2.payroll_action_id = appa3.payroll_action_id
412: AND appa3.action_type = 'V'

Line 489: ,pay_payroll_actions prepay_payact

485: SELECT distinct prepay_payact.payroll_action_id prepay_payact_id
486: ,run_payact.date_earned date_earned
487: FROM pay_action_interlocks archive_intlck
488: ,pay_assignment_actions prepay_assact
489: ,pay_payroll_actions prepay_payact
490: ,pay_action_interlocks prepay_intlck
491: ,pay_assignment_actions run_assact
492: ,pay_payroll_actions run_payact
493: ,pay_assignment_actions archive_assact

Line 492: ,pay_payroll_actions run_payact

488: ,pay_assignment_actions prepay_assact
489: ,pay_payroll_actions prepay_payact
490: ,pay_action_interlocks prepay_intlck
491: ,pay_assignment_actions run_assact
492: ,pay_payroll_actions run_payact
493: ,pay_assignment_actions archive_assact
494: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
495: and archive_assact.payroll_action_id = p_payroll_action_id
496: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 511: ,pay_payroll_actions prepay_payact

507: ,run_payact.date_earned date_earned
508: ,run_payact.payroll_action_id run_payact_id
509: FROM pay_action_interlocks archive_intlck
510: ,pay_assignment_actions prepay_assact
511: ,pay_payroll_actions prepay_payact
512: ,pay_action_interlocks prepay_intlck
513: ,pay_assignment_actions run_assact
514: ,pay_payroll_actions run_payact
515: ,pay_assignment_actions archive_assact

Line 514: ,pay_payroll_actions run_payact

510: ,pay_assignment_actions prepay_assact
511: ,pay_payroll_actions prepay_payact
512: ,pay_action_interlocks prepay_intlck
513: ,pay_assignment_actions run_assact
514: ,pay_payroll_actions run_payact
515: ,pay_assignment_actions archive_assact
516: WHERE archive_intlck.locking_action_id = archive_assact.assignment_action_id
517: and archive_assact.payroll_action_id = p_payroll_action_id
518: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id

Line 1458: ,pay_payroll_actions ppa

1454: ,pay_element_types_f pet
1455: ,pay_element_links_f pel
1456: ,pay_element_entries_f pee
1457: ,pay_assignment_actions paa
1458: ,pay_payroll_actions ppa
1459: WHERE pet.element_type_id = pap.accrual_plan_element_type_id
1460: AND pel.element_type_id = pet.element_type_id
1461: AND pee.element_link_id = pel.element_link_id
1462: AND paa.assignment_id = pee.assignment_id

Line 1612: ,pay_payroll_actions ppa

1608: SELECT rrv.result_value
1609: FROM pay_run_result_values rrv
1610: ,pay_run_results rr
1611: ,pay_assignment_actions paa
1612: ,pay_payroll_actions ppa
1613: WHERE rrv.input_value_id = p_iv_id
1614: AND rr.element_type_id = p_ele_type_id
1615: AND rr.run_result_id = rrv.run_result_id
1616: AND rr.assignment_action_id = paa.assignment_action_id

Line 2541: ,pay_payroll_actions prepay_payact

2537: ,run_payact.payroll_action_id run_payact_id
2538: ,run_payact.payroll_id payroll_id
2539: FROM pay_action_interlocks archive_intlck
2540: ,pay_assignment_actions prepay_assact
2541: ,pay_payroll_actions prepay_payact
2542: ,pay_action_interlocks prepay_intlck
2543: ,pay_assignment_actions run_assact
2544: ,pay_payroll_actions run_payact
2545: WHERE archive_intlck.locking_action_id = p_locking_action_id

Line 2544: ,pay_payroll_actions run_payact

2540: ,pay_assignment_actions prepay_assact
2541: ,pay_payroll_actions prepay_payact
2542: ,pay_action_interlocks prepay_intlck
2543: ,pay_assignment_actions run_assact
2544: ,pay_payroll_actions run_payact
2545: WHERE archive_intlck.locking_action_id = p_locking_action_id
2546: AND prepay_assact.assignment_action_id = archive_intlck.locked_action_id
2547: AND prepay_payact.payroll_action_id = prepay_assact.payroll_action_id
2548: AND prepay_payact.action_type IN ('U','P')

Line 2563: ,pay_payroll_actions ppa

2559: ppa.date_earned date_earned,
2560: ppa.effective_date effective_date,
2561: ptp.start_date start_date
2562: FROM per_time_periods ptp
2563: ,pay_payroll_actions ppa
2564: ,pay_assignment_actions paa
2565: WHERE ptp.payroll_id =ppa.payroll_id
2566: AND ppa.payroll_action_id =paa.payroll_action_id
2567: AND paa.assignment_action_id =p_assact_id

Line 2590: l_date_earned pay_payroll_actions.date_earned%TYPE;

2586: l_end_date per_time_periods.end_date%TYPE;
2587: l_pre_end_date per_time_periods.end_date%TYPE;
2588: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2589: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2590: l_date_earned pay_payroll_actions.date_earned%TYPE;
2591: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2592: l_effective_date pay_payroll_actions.effective_date%TYPE;
2593: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2594: l_run_payact_id NUMBER;

Line 2591: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

2587: l_pre_end_date per_time_periods.end_date%TYPE;
2588: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2589: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2590: l_date_earned pay_payroll_actions.date_earned%TYPE;
2591: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2592: l_effective_date pay_payroll_actions.effective_date%TYPE;
2593: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2594: l_run_payact_id NUMBER;
2595: l_action_context_id NUMBER;

Line 2592: l_effective_date pay_payroll_actions.effective_date%TYPE;

2588: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2589: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2590: l_date_earned pay_payroll_actions.date_earned%TYPE;
2591: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2592: l_effective_date pay_payroll_actions.effective_date%TYPE;
2593: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2594: l_run_payact_id NUMBER;
2595: l_action_context_id NUMBER;
2596: g_archive_pact NUMBER;

Line 2593: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

2589: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
2590: l_date_earned pay_payroll_actions.date_earned%TYPE;
2591: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
2592: l_effective_date pay_payroll_actions.effective_date%TYPE;
2593: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
2594: l_run_payact_id NUMBER;
2595: l_action_context_id NUMBER;
2596: g_archive_pact NUMBER;
2597: p_assactid NUMBER;

Line 2787: ,pay_payroll_actions ppa

2783: SELECT rrv.result_value
2784: FROM pay_run_result_values rrv
2785: ,pay_run_results rr
2786: ,pay_assignment_actions paa
2787: ,pay_payroll_actions ppa
2788: WHERE rrv.input_value_id = p_iv_id
2789: AND rr.element_type_id = p_ele_type_id
2790: AND rr.run_result_id = rrv.run_result_id
2791: AND rr.assignment_action_id = paa.assignment_action_id

Line 2902: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is

2898:
2899: END ARCHIVE_MAIN_ELEMENTS;
2900:
2901: PROCEDURE DEINITIALIZATION_CODE
2902: (p_payroll_action_id in pay_payroll_actions.payroll_action_id%type) is
2903:
2904: CURSOR csr_scl_details (p_payroll_action_id pay_action_information.action_information1%TYPE , p_effective_date DATE ) IS
2905: SELECT DISTINCT segment2 local_unit , paaf.business_group_id
2906: FROM per_all_assignments_f paaf

Line 2947: FROM pay_payroll_actions

2943: AND hou.location_id = hla.location_id;
2944:
2945: CURSOR csr_effective_date (p_payroll_action_id pay_action_information.action_information1%TYPE ) IS
2946: SELECT effective_date
2947: FROM pay_payroll_actions
2948: WHERE payroll_action_id= p_payroll_action_id ;
2949:
2950:
2951: l_org_exists NUMBER ;