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

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

40: p_segment_number IN NUMBER DEFAULT NULL
41: )
42: RETURN VARCHAR2
43: IS
44: l_parameter pay_payroll_actions.legislative_parameters%TYPE := NULL;
45: l_start_pos NUMBER;
46: l_delimiter VARCHAR2 (1) := ' ';
47: l_proc VARCHAR2 (40) := g_package
48: || ' get parameter ';

Line 186: FROM pay_payroll_actions

182: )
183: )
184: period_end_date,
185: effective_date effective_date, business_group_id bg_id
186: FROM pay_payroll_actions
187: WHERE payroll_action_id = p_payroll_action_id;
188:
189: lr_parameter_info csr_parameter_info%ROWTYPE;
190: l_proc VARCHAR2 (240)

Line 316: ,pay_payroll_actions ppa

312: fnd_file.put_line (fnd_file.LOG, 'Entering Procedure RANGE_CODE 7');
313: p_sql :=
314: 'SELECT DISTINCT person_id
315: FROM per_people_f ppf
316: ,pay_payroll_actions ppa
317: WHERE ppa.payroll_action_id = :payroll_action_id
318: AND ppa.business_group_id = ppf.business_group_id
319: ORDER BY ppf.person_id';
320: pay_fi_archive_umfr.get_all_parameters (

Line 604: FROM pay_payroll_actions ppa

600:
601: SELECT act.assignment_id assignment_id,
602: act.assignment_action_id run_action_id,
603: act1.assignment_action_id prepaid_action_id
604: FROM pay_payroll_actions ppa
605: ,pay_payroll_actions appa
606: ,pay_payroll_actions appa2
607: ,pay_assignment_actions act
608: ,pay_assignment_actions act1

Line 605: ,pay_payroll_actions appa

601: SELECT act.assignment_id assignment_id,
602: act.assignment_action_id run_action_id,
603: act1.assignment_action_id prepaid_action_id
604: FROM pay_payroll_actions ppa
605: ,pay_payroll_actions appa
606: ,pay_payroll_actions appa2
607: ,pay_assignment_actions act
608: ,pay_assignment_actions act1
609: ,pay_action_interlocks pai

Line 606: ,pay_payroll_actions appa2

602: act.assignment_action_id run_action_id,
603: act1.assignment_action_id prepaid_action_id
604: FROM pay_payroll_actions ppa
605: ,pay_payroll_actions appa
606: ,pay_payroll_actions appa2
607: ,pay_assignment_actions act
608: ,pay_assignment_actions act1
609: ,pay_action_interlocks pai
610: ,per_all_assignments_f as1

Line 672: FROM pay_payroll_actions ppa

668: and PIV.name='Third Party Payee'
669: and TARGET.result_value = to_char(p_trade_union_id)
670: and act.assignment_id IN
671: (SELECT MIN(act.assignment_id)
672: FROM pay_payroll_actions ppa
673: ,pay_payroll_actions appa
674: ,pay_payroll_actions appa2
675: ,pay_assignment_actions act
676: ,pay_assignment_actions act1

Line 673: ,pay_payroll_actions appa

669: and TARGET.result_value = to_char(p_trade_union_id)
670: and act.assignment_id IN
671: (SELECT MIN(act.assignment_id)
672: FROM pay_payroll_actions ppa
673: ,pay_payroll_actions appa
674: ,pay_payroll_actions appa2
675: ,pay_assignment_actions act
676: ,pay_assignment_actions act1
677: ,pay_action_interlocks pai

Line 674: ,pay_payroll_actions appa2

670: and act.assignment_id IN
671: (SELECT MIN(act.assignment_id)
672: FROM pay_payroll_actions ppa
673: ,pay_payroll_actions appa
674: ,pay_payroll_actions appa2
675: ,pay_assignment_actions act
676: ,pay_assignment_actions act1
677: ,pay_action_interlocks pai
678: ,per_all_assignments_f as1

Line 742: FROM pay_payroll_actions ppa

738: GROUP BY as1.person_id
739: )
740: and (act.assignment_id ,act.assignment_action_id ) IN
741: (SELECT act.assignment_id , max(act.assignment_action_id )
742: FROM pay_payroll_actions ppa
743: ,pay_payroll_actions appa
744: ,pay_payroll_actions appa2
745: ,pay_assignment_actions act
746: ,pay_assignment_actions act1

Line 743: ,pay_payroll_actions appa

739: )
740: and (act.assignment_id ,act.assignment_action_id ) IN
741: (SELECT act.assignment_id , max(act.assignment_action_id )
742: FROM pay_payroll_actions ppa
743: ,pay_payroll_actions appa
744: ,pay_payroll_actions appa2
745: ,pay_assignment_actions act
746: ,pay_assignment_actions act1
747: ,pay_action_interlocks pai

Line 744: ,pay_payroll_actions appa2

740: and (act.assignment_id ,act.assignment_action_id ) IN
741: (SELECT act.assignment_id , max(act.assignment_action_id )
742: FROM pay_payroll_actions ppa
743: ,pay_payroll_actions appa
744: ,pay_payroll_actions appa2
745: ,pay_assignment_actions act
746: ,pay_assignment_actions act1
747: ,pay_action_interlocks pai
748: ,per_all_assignments_f as1

Line 990: pay_payroll_actions prepay_payact,

986: SELECT DISTINCT prepay_payact.payroll_action_id prepay_payact_id,
987: run_payact.date_earned date_earned
988: FROM pay_action_interlocks archive_intlck,
989: pay_assignment_actions prepay_assact,
990: pay_payroll_actions prepay_payact,
991: pay_action_interlocks prepay_intlck,
992: pay_assignment_actions run_assact,
993: pay_payroll_actions run_payact,
994: pay_assignment_actions archive_assact

Line 993: pay_payroll_actions run_payact,

989: pay_assignment_actions prepay_assact,
990: pay_payroll_actions prepay_payact,
991: pay_action_interlocks prepay_intlck,
992: pay_assignment_actions run_assact,
993: pay_payroll_actions run_payact,
994: pay_assignment_actions archive_assact
995: WHERE archive_intlck.locking_action_id =
996: archive_assact.assignment_action_id
997: AND archive_assact.payroll_action_id =

Line 1021: pay_payroll_actions prepay_payact,

1017: run_payact.date_earned date_earned,
1018: run_payact.payroll_action_id run_payact_id
1019: FROM pay_action_interlocks archive_intlck,
1020: pay_assignment_actions prepay_assact,
1021: pay_payroll_actions prepay_payact,
1022: pay_action_interlocks prepay_intlck,
1023: pay_assignment_actions run_assact,
1024: pay_payroll_actions run_payact,
1025: pay_assignment_actions archive_assact

Line 1024: pay_payroll_actions run_payact,

1020: pay_assignment_actions prepay_assact,
1021: pay_payroll_actions prepay_payact,
1022: pay_action_interlocks prepay_intlck,
1023: pay_assignment_actions run_assact,
1024: pay_payroll_actions run_payact,
1025: pay_assignment_actions archive_assact
1026: WHERE archive_intlck.locking_action_id =
1027: archive_assact.assignment_action_id
1028: AND archive_assact.payroll_action_id =

Line 1177: pay_payroll_actions prepay_payact,

1173: run_payact.payroll_action_id run_payact_id,
1174: run_payact.payroll_id payroll_id
1175: FROM pay_action_interlocks archive_intlck,
1176: pay_assignment_actions prepay_assact,
1177: pay_payroll_actions prepay_payact,
1178: pay_action_interlocks prepay_intlck,
1179: pay_assignment_actions run_assact,
1180: pay_payroll_actions run_payact
1181: WHERE archive_intlck.locking_action_id = p_locking_action_id

Line 1180: pay_payroll_actions run_payact

1176: pay_assignment_actions prepay_assact,
1177: pay_payroll_actions prepay_payact,
1178: pay_action_interlocks prepay_intlck,
1179: pay_assignment_actions run_assact,
1180: pay_payroll_actions run_payact
1181: WHERE archive_intlck.locking_action_id = p_locking_action_id
1182: AND prepay_assact.assignment_action_id =
1183: archive_intlck.locked_action_id
1184: AND prepay_payact.payroll_action_id =

Line 1205: pay_payroll_actions ppa,

1201: ptp.time_period_id time_period_id,
1202: ppa.date_earned date_earned,
1203: ppa.effective_date effective_date, ptp.start_date start_date
1204: FROM per_time_periods ptp,
1205: pay_payroll_actions ppa,
1206: pay_assignment_actions paa
1207: WHERE ptp.payroll_id = ppa.payroll_id
1208: AND ppa.payroll_action_id = paa.payroll_action_id
1209: AND paa.assignment_action_id = p_assact_id

Line 1227: l_date_earned pay_payroll_actions.date_earned%TYPE;

1223: l_end_date per_time_periods.end_date%TYPE;
1224: l_pre_end_date per_time_periods.end_date%TYPE;
1225: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1226: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1227: l_date_earned pay_payroll_actions.date_earned%TYPE;
1228: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
1229: l_effective_date pay_payroll_actions.effective_date%TYPE;
1230: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
1231: l_run_payact_id NUMBER;

Line 1228: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

1224: l_pre_end_date per_time_periods.end_date%TYPE;
1225: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1226: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1227: l_date_earned pay_payroll_actions.date_earned%TYPE;
1228: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
1229: l_effective_date pay_payroll_actions.effective_date%TYPE;
1230: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
1231: l_run_payact_id NUMBER;
1232: l_action_context_id NUMBER;

Line 1229: l_effective_date pay_payroll_actions.effective_date%TYPE;

1225: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1226: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1227: l_date_earned pay_payroll_actions.date_earned%TYPE;
1228: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
1229: l_effective_date pay_payroll_actions.effective_date%TYPE;
1230: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
1231: l_run_payact_id NUMBER;
1232: l_action_context_id NUMBER;
1233: g_archive_pact NUMBER;

Line 1230: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

1226: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
1227: l_date_earned pay_payroll_actions.date_earned%TYPE;
1228: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
1229: l_effective_date pay_payroll_actions.effective_date%TYPE;
1230: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;
1231: l_run_payact_id NUMBER;
1232: l_action_context_id NUMBER;
1233: g_archive_pact NUMBER;
1234: p_assactid NUMBER;