DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_UMFR dependencies on PAY_ACTION_INTERLOCKS

Line 609: ,pay_action_interlocks pai

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
613: ,pay_run_results RR

Line 677: ,pay_action_interlocks pai

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
681: ,pay_run_results RR

Line 747: ,pay_action_interlocks pai

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
751: ,pay_run_results RR

Line 988: FROM pay_action_interlocks archive_intlck,

984: CURSOR csr_prepay_id
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,

Line 991: pay_action_interlocks prepay_intlck,

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

Line 1019: FROM pay_action_interlocks archive_intlck,

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

Line 1022: pay_action_interlocks prepay_intlck,

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

Line 1175: FROM pay_action_interlocks archive_intlck,

1171: run_assact.assignment_id run_assgt_id,
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,

Line 1178: pay_action_interlocks prepay_intlck,

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