APPS.PAY_JP_UITE_REPORT_PKG dependencies on PER_ASSIGNMENTS_F

Line 688: , p_business_group_id per_assignments_f.business_group_id%TYPE

684: -- None
685: --************************************************************************
686: AS
687: CURSOR lcu_assact_r( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
688: , p_business_group_id per_assignments_f.business_group_id%TYPE
689: )
690: IS
691: SELECT DISTINCT PJUIEV.assignment_id
692: ,PJUIEV.termination_date

Line 693: FROM per_assignments_f PAA

689: )
690: IS
691: SELECT DISTINCT PJUIEV.assignment_id
692: ,PJUIEV.termination_date
693: FROM per_assignments_f PAA
694: ,per_people_f PAP
695: ,pay_assignment_actions PAS
696: ,pay_jp_uite_emp_v PJUIEV
697: ,per_periods_of_service PPOF

Line 721: , p_business_group_id per_assignments_f.business_group_id%TYPE

717:
718:
719: --
720: CURSOR lcu_assact( p_payroll_action_id_arch pay_payroll_actions.payroll_action_id%TYPE
721: , p_business_group_id per_assignments_f.business_group_id%TYPE
722: )
723: IS
724: SELECT DISTINCT PJUIEV.assignment_id
725: ,PJUIEV.termination_date

Line 726: FROM per_assignments_f PAA

722: )
723: IS
724: SELECT DISTINCT PJUIEV.assignment_id
725: ,PJUIEV.termination_date
726: FROM per_assignments_f PAA
727: ,per_people_f PAP
728: ,pay_assignment_actions PAS
729: ,pay_jp_uite_emp_v PJUIEV
730: ,per_periods_of_service PPOF

Line 1589: FROM per_assignments_f PAF

1585: lc_order_by := 'NVL(PPS.actual_termination_date,PPS.projected_termination_date),UPPER(PPF.employee_number)' ;
1586: END IF;
1587:
1588: sqlstr := ' SELECT PAA.rowid
1589: FROM per_assignments_f PAF
1590: ,pay_assignment_actions PAA
1591: ,per_people_f PPF
1592: ,hr_all_organization_units_tl HAOUT
1593: ,hr_all_organization_units HAOU