APPS.PAY_DK_STATSR_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 741: ,per_all_assignments_f paaf

737: ,paaf.location_id LOC_ID
738: ,papf.person_id --9865127
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

Line 822: ,per_all_assignments_f paaf

818: ,paaf.organization_id HR_ORG_ID
819: ,paaf.location_id LOC_ID
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

Line 856: per_all_assignments_f paaf

852: select
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

Line 895: per_all_assignments_f paaf

891: ,NVL(scl.segment3,'XXX') segment3
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

Line 1114: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;

1110:
1111: --9865127
1112:
1113: l_bal_todate DATE;
1114: l_hourly_salaried per_all_assignments_f.hourly_salaried_code%TYPE ;
1115: l_loc_id NUMBER;
1116: l_hr_org_id NUMBER;
1117: l_old_loc_id NUMBER;
1118: l_pd_date_to DATE; --8848543