DBA Data[Home] [Help]

APPS.PAY_FI_ARCHIVE_TEL dependencies on HR_SOFT_CODING_KEYFLEX

Line 653: ,hr_soft_coding_keyflex hsck

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
655: WHERE ppa.payroll_action_id = p_payroll_action_id
656: AND appa.effective_date BETWEEN l_canonical_start_date
657: AND l_canonical_end_date

Line 1152: ,HR_SOFT_CODING_KEYFLEX scl

1148: cursor csr_get_Segment2
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