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

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

35: p_parameter_string IN VARCHAR2
36: ,p_token IN VARCHAR2
37: ,p_segment_number IN NUMBER default NULL ) RETURN VARCHAR2
38: IS
39: l_parameter pay_payroll_actions.legislative_parameters%TYPE:=NULL;
40: l_start_pos NUMBER;
41: l_delimiter VARCHAR2(1):=' ';
42: l_proc VARCHAR2(40):= g_package||' get parameter ';
43:

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

81: , p_segment_number IN NUMBER DEFAULT NULL
82: )
83: RETURN VARCHAR2
84: IS
85: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
86: l_start_pos NUMBER;
87: l_delimiter VARCHAR2 (1) := ' ';
88: l_proc VARCHAR2 (40) := g_package || ' get parameter ';
89: BEGIN

Line 196: FROM pay_payroll_actions

192: , 'EFFECTIVE_END_DATE'
193: )
194: ) eff_end_date
195: , effective_date effective_date, business_group_id bg_id
196: FROM pay_payroll_actions
197: WHERE payroll_action_id = p_payroll_action_id;
198:
199: lr_parameter_info csr_parameter_info%ROWTYPE;
200: l_proc VARCHAR2 (240)

Line 319: FROM pay_payroll_actions appa

315: , csr_v_canonical_end_date DATE
316: )
317: IS
318: SELECT '1'
319: FROM pay_payroll_actions appa
320: , pay_assignment_actions act
321: , per_all_assignments_f as1
322: , pay_payroll_actions ppa
323: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 322: , pay_payroll_actions ppa

318: SELECT '1'
319: FROM pay_payroll_actions appa
320: , pay_assignment_actions act
321: , per_all_assignments_f as1
322: , pay_payroll_actions ppa
323: WHERE ppa.payroll_action_id = p_payroll_action_id
324: AND appa.effective_date BETWEEN csr_v_canonical_start_date
325: AND csr_v_canonical_end_date
326: AND appa.action_type IN ('R', 'Q')

Line 353: ,pay_payroll_actions ppa

349:
350: p_sql :=
351: 'SELECT DISTINCT person_id
352: FROM per_people_f ppf
353: ,pay_payroll_actions ppa
354: WHERE ppa.payroll_action_id = :payroll_action_id
355: AND ppa.business_group_id = ppf.business_group_id
356: ORDER BY ppf.person_id';
357: g_payroll_action_id := p_payroll_action_id;

Line 539: FROM pay_payroll_actions ppa

535: IS
536: /* SELECT as1.person_id person_id, act.assignment_id assignment_id
537: , act.assignment_action_id run_action_id
538: , act1.assignment_action_id prepaid_action_id
539: FROM pay_payroll_actions ppa
540: , pay_payroll_actions appa
541: , pay_payroll_actions appa2
542: , pay_assignment_actions act
543: , pay_assignment_actions act1

Line 540: , pay_payroll_actions appa

536: /* SELECT as1.person_id person_id, act.assignment_id assignment_id
537: , act.assignment_action_id run_action_id
538: , act1.assignment_action_id prepaid_action_id
539: FROM pay_payroll_actions ppa
540: , pay_payroll_actions appa
541: , pay_payroll_actions appa2
542: , pay_assignment_actions act
543: , pay_assignment_actions act1
544: , pay_action_interlocks pai

Line 541: , pay_payroll_actions appa2

537: , act.assignment_action_id run_action_id
538: , act1.assignment_action_id prepaid_action_id
539: FROM pay_payroll_actions ppa
540: , pay_payroll_actions appa
541: , pay_payroll_actions appa2
542: , pay_assignment_actions act
543: , pay_assignment_actions act1
544: , pay_action_interlocks pai
545: , per_all_assignments_f as1

Line 573: FROM pay_payroll_actions appa

569: ORDER BY as1.person_id, act.assignment_id;
570: */
571: SELECT as1.person_id person_id, act.assignment_id assignment_id
572: , act.assignment_action_id run_action_id
573: FROM pay_payroll_actions appa
574: , pay_assignment_actions act
575: , per_all_assignments_f as1
576: , pay_payroll_actions ppa
577: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 576: , pay_payroll_actions ppa

572: , act.assignment_action_id run_action_id
573: FROM pay_payroll_actions appa
574: , pay_assignment_actions act
575: , per_all_assignments_f as1
576: , pay_payroll_actions ppa
577: WHERE ppa.payroll_action_id = p_payroll_action_id
578: AND appa.effective_date BETWEEN l_canonical_start_date
579: AND l_canonical_end_date
580: AND as1.person_id BETWEEN p_start_person AND p_end_person

Line 920: l_date_earned pay_payroll_actions.date_earned%TYPE;

916:
917: lr_get_defined_balance_id csr_get_defined_balance_id%ROWTYPE;
918: l_actid NUMBER;
919: l_end_date per_time_periods.end_date%TYPE;
920: l_date_earned pay_payroll_actions.date_earned%TYPE;
921: l_effective_date pay_payroll_actions.effective_date%TYPE;
922: l_start_date per_time_periods.start_date%TYPE;
923: l_action_info_id pay_action_information.action_information_id%TYPE;
924: l_ovn pay_action_information.object_version_number%TYPE;

Line 921: l_effective_date pay_payroll_actions.effective_date%TYPE;

917: lr_get_defined_balance_id csr_get_defined_balance_id%ROWTYPE;
918: l_actid NUMBER;
919: l_end_date per_time_periods.end_date%TYPE;
920: l_date_earned pay_payroll_actions.date_earned%TYPE;
921: l_effective_date pay_payroll_actions.effective_date%TYPE;
922: l_start_date per_time_periods.start_date%TYPE;
923: l_action_info_id pay_action_information.action_information_id%TYPE;
924: l_ovn pay_action_information.object_version_number%TYPE;
925: l_flag NUMBER := 0;

Line 1612: FROM pay_payroll_actions ppa

1608: THEN
1609: BEGIN
1610: SELECT payroll_action_id
1611: INTO l_payroll_action_id
1612: FROM pay_payroll_actions ppa
1613: , fnd_conc_req_summary_v fcrs
1614: , fnd_conc_req_summary_v fcrs1
1615: WHERE fcrs.request_id = fnd_global.conc_request_id
1616: AND fcrs.priority_request_id = fcrs1.priority_request_id