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_ASSIGNMENT_ACTIONS

Line 607: ,pay_assignment_actions act

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
611: ,hr_soft_coding_keyflex hsck

Line 608: ,pay_assignment_actions act1

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
611: ,hr_soft_coding_keyflex hsck
612: ,pay_run_result_values TARGET

Line 654: from pay_assignment_actions act2

650: AND act.TAX_UNIT_ID = p_legal_employer_id
651: and TARGET.run_result_id = RR.run_result_id
652: AND (( RR.assignment_action_id
653: in ( Select act2.assignment_action_id
654: from pay_assignment_actions act2
655: Where act2.source_action_id=act.assignment_action_id
656: AND act2.action_status = 'C' -- Completed
657: AND act2.payroll_action_id = act.payroll_action_id))
658: or

Line 675: ,pay_assignment_actions act

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
679: ,hr_soft_coding_keyflex hsck

Line 676: ,pay_assignment_actions act1

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
679: ,hr_soft_coding_keyflex hsck
680: ,pay_run_result_values TARGET

Line 722: from pay_assignment_actions act2

718: AND act.TAX_UNIT_ID = p_legal_employer_id
719: and TARGET.run_result_id = RR.run_result_id
720: AND (( RR.assignment_action_id
721: in ( Select act2.assignment_action_id
722: from pay_assignment_actions act2
723: Where act2.source_action_id=act.assignment_action_id
724: AND act2.action_status = 'C' -- Completed
725: AND act2.payroll_action_id = act.payroll_action_id))
726: or

Line 745: ,pay_assignment_actions act

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
749: ,hr_soft_coding_keyflex hsck

Line 746: ,pay_assignment_actions act1

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
749: ,hr_soft_coding_keyflex hsck
750: ,pay_run_result_values TARGET

Line 790: from pay_assignment_actions act2

786: AND act.TAX_UNIT_ID = p_legal_employer_id
787: and TARGET.run_result_id = RR.run_result_id
788: AND (( RR.assignment_action_id
789: in ( Select act2.assignment_action_id
790: from pay_assignment_actions act2
791: Where act2.source_action_id=act.assignment_action_id
792: AND act2.action_status = 'C' -- Completed
793: AND act2.payroll_action_id = act.payroll_action_id))
794: or

Line 929: SELECT pay_assignment_actions_s.NEXTVAL

925: -- IF l_prepay_action_id <>
926: -- rec_prepaid_assignments.prepaid_action_id --pp
927: if l_assignment <> rec_prepaid_assignments.assignment_id then
928: -- THEN
929: SELECT pay_assignment_actions_s.NEXTVAL
930: INTO l_actid
931: FROM DUAL;
932:
933: --

Line 989: pay_assignment_actions prepay_assact,

985: IS
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,

Line 992: pay_assignment_actions run_assact,

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
995: WHERE archive_intlck.locking_action_id =
996: archive_assact.assignment_action_id

Line 994: pay_assignment_actions archive_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 =
998: p_payroll_action_id

Line 1020: pay_assignment_actions prepay_assact,

1016: SELECT DISTINCT prepay_payact.payroll_action_id prepay_payact_id,
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,

Line 1023: pay_assignment_actions run_assact,

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
1026: WHERE archive_intlck.locking_action_id =
1027: archive_assact.assignment_action_id

Line 1025: pay_assignment_actions archive_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 =
1029: p_payroll_action_id

Line 1176: pay_assignment_actions prepay_assact,

1172: run_assact.assignment_action_id run_assact_id,
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

Line 1179: pay_assignment_actions run_assact,

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
1182: AND prepay_assact.assignment_action_id =
1183: archive_intlck.locked_action_id

Line 1206: pay_assignment_actions paa

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
1210: AND ppa.payroll_action_id = p_pay_act_id

Line 1217: FROM pay_assignment_actions

1213: /* Cursor to retrieve Archive Payroll Action Id */
1214: CURSOR csr_archive_payact (p_assignment_action_id NUMBER)
1215: IS
1216: SELECT payroll_action_id
1217: FROM pay_assignment_actions
1218: WHERE assignment_action_id = p_assignment_action_id;
1219:
1220: l_archive_payact_id NUMBER;
1221: l_record_count NUMBER;

Line 1281: pay_assignment_actions pasa

1277: pap.per_information19 membership_end_date
1278: FROM per_all_people_f pap,
1279: per_all_assignments_f paa,
1280: hr_soft_coding_keyflex scl,
1281: pay_assignment_actions pasa
1282: WHERE paa.person_id = pap.person_id
1283: AND pasa.assignment_id = paa.assignment_id
1284: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id
1285: AND pap.effective_start_date <= g_period_end_date

Line 1322: pay_assignment_actions pasa

1318: IS
1319: SELECT scl.segment2
1320: FROM per_all_assignments_f paa,
1321: hr_soft_coding_keyflex scl,
1322: pay_assignment_actions pasa
1323: WHERE pasa.assignment_action_id = p_assignment_action_id
1324: AND pasa.assignment_id = paa.assignment_id
1325: AND scl.soft_coding_keyflex_id = paa.soft_coding_keyflex_id;
1326: