APPS.PAY_FI_ARCHIVE_TEL dependencies on PAY_ASSIGNMENT_ACTIONS

Line 649: ,pay_assignment_actions act

645: act1.assignment_action_id prepaid_action_id
646: FROM pay_payroll_actions ppa
647: ,pay_payroll_actions appa
648: ,pay_payroll_actions appa2
649: ,pay_assignment_actions act
650: ,pay_assignment_actions act1
651: ,pay_action_interlocks pai
652: ,per_all_assignments_f as1
653: ,hr_soft_coding_keyflex hsck

Line 650: ,pay_assignment_actions act1

646: FROM pay_payroll_actions ppa
647: ,pay_payroll_actions appa
648: ,pay_payroll_actions appa2
649: ,pay_assignment_actions act
650: ,pay_assignment_actions act1
651: ,pay_action_interlocks pai
652: ,per_all_assignments_f as1
653: ,hr_soft_coding_keyflex hsck
654: , per_all_people_f pap

Line 700: pay_assignment_actions act,

696: act1.assignment_action_id prepaid_action_id
697: FROM pay_payroll_actions ppa,
698: pay_payroll_actions appa,
699: pay_payroll_actions appa2,
700: pay_assignment_actions act,
701: pay_assignment_actions act1,
702: pay_action_interlocks pai,
703: per_all_assignments_f as1
704: , per_all_people_f pap

Line 701: pay_assignment_actions act1,

697: FROM pay_payroll_actions ppa,
698: pay_payroll_actions appa,
699: pay_payroll_actions appa2,
700: pay_assignment_actions act,
701: pay_assignment_actions act1,
702: pay_action_interlocks pai,
703: per_all_assignments_f as1
704: , per_all_people_f pap
705: WHERE ppa.payroll_action_id = p_payroll_action_id

Line 834: SELECT pay_assignment_actions_s.NEXTVAL

830: ,l_canonical_end_date)
831: LOOP
832: fnd_file.put_line(fnd_file.log,' LU Inside the Csr Prepaid Cursor ');
833: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
834: SELECT pay_assignment_actions_s.NEXTVAL
835: INTO l_actid
836: FROM dual;
837: --
838: g_index_assact := g_index_assact + 1;

Line 867: SELECT pay_assignment_actions_s.NEXTVAL

863: ,l_canonical_end_date)
864: LOOP
865: fnd_file.put_line(fnd_file.log,' LE Inside the Csr Prepaid Cursor ');
866: IF l_prepay_action_id <> rec_prepaid_assignments.prepaid_action_id THEN
867: SELECT pay_assignment_actions_s.NEXTVAL
868: INTO l_actid
869: FROM dual;
870: --
871: g_index_assact := g_index_assact + 1;

Line 1135: pay_assignment_actions pac,

1131: pap.PER_INFORMATION21,
1132: pap.PER_INFORMATION24,
1133: pac.assignment_id
1134: FROM
1135: pay_assignment_actions pac,
1136: per_all_assignments_f paa,
1137: per_all_people_f pap
1138: WHERE pac.assignment_action_id = p_asg_act_id
1139: AND paa.assignment_id = pac.assignment_id

Line 1153: ,pay_assignment_actions pasa

1149: is
1150: SELECT scl.segment2,scl.segment8
1151: FROM PER_ALL_ASSIGNMENTS_F paa
1152: ,HR_SOFT_CODING_KEYFLEX scl
1153: ,pay_assignment_actions pasa
1154: WHERE pasa.ASSIGNMENT_ACTION_ID = p_assignment_action_id
1155: AND pasa.ASSIGNMENT_ID = paa.ASSIGNMENT_ID
1156: AND scl.soft_coding_keyflex_id=paa.soft_coding_keyflex_id
1157: AND paa.primary_flag='Y'