DBA Data[Home] [Help]

APPS.PAY_DK_STATSR_PKG dependencies on HR_SOFT_CODING_KEYFLEX

Line 743: ,hr_soft_coding_keyflex scl

739: FROM
740: per_all_people_f papf
741: ,per_all_assignments_f paaf
742: ,pay_payrolls_f ppf
743: ,hr_soft_coding_keyflex scl
744: ,pay_assignment_actions paa
745: ,pay_payroll_actions ppa
746: ,per_time_periods ptp --8848543
747: WHERE paaf.person_id BETWEEN p_start_person AND p_end_person

Line 824: ,hr_soft_coding_keyflex scl

820: FROM
821: per_all_people_f papf
822: ,per_all_assignments_f paaf
823: ,pay_payrolls_f ppf
824: ,hr_soft_coding_keyflex scl
825: WHERE paaf.person_id = p_person_id
826: AND papf.PERSON_ID = paaf.PERSON_ID
827: AND ppf.payroll_id = p_payroll_id
828: AND paaf.payroll_id = ppf.payroll_id

Line 857: ,hr_soft_coding_keyflex scl

853: paaf.effective_start_date ASG_START_DATE
854: ,paaf.effective_end_date ASG_END_DATE
855: FROM
856: per_all_assignments_f paaf
857: ,hr_soft_coding_keyflex scl
858: where
859: paaf.assignment_id = p_assignment_id1
860: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
861: AND scl.enabled_flag = 'Y'

Line 896: ,hr_soft_coding_keyflex scl

892: ,NVL(scl.segment4,'XXX') segment4
893: ,NVL(paaf.location_id,-999) location_id
894: FROM
895: per_all_assignments_f paaf
896: ,hr_soft_coding_keyflex scl
897: where
898: paaf.assignment_id = p_assignment_id1
899: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
900: AND scl.enabled_flag = 'Y'