APPS.PAY_JP_UITE_ARCH_PKG dependencies on PER_ASSIGNMENTS_F

Line 927: ,per_assignments_f PAF

923: PAF.effective_end_date
924: FROM pay_assignment_actions PAA
925: ,pay_payroll_actions PPA
926: ,per_time_periods PTP
927: ,per_assignments_f PAF
928: WHERE PAA.assignment_id = p_assignment_id
929: AND PAF.assignment_id = PAA.assignment_id
930: AND PAA.action_status = 'C'
931: AND PPA.payroll_action_id = PAA.payroll_action_id

Line 964: ,per_assignments_f PAF

960: PAF.effective_end_date
961: FROM pay_assignment_actions PAA
962: ,pay_payroll_actions PPA
963: ,per_time_periods PTP
964: ,per_assignments_f PAF
965: WHERE PAA.assignment_id = p_assignment_id
966: AND PAF.assignment_id = PAA.assignment_id
967: AND PAA.action_status = 'C'
968: AND PPA.payroll_action_id = PAA.payroll_action_id

Line 2396: CURSOR lcu_emp_assignment_det_r ( p_business_group_id per_assignments_f.business_group_id%TYPE

2392: -- PYUGEN process
2393: --************************************************************************
2394: IS
2395: --
2396: CURSOR lcu_emp_assignment_det_r ( p_business_group_id per_assignments_f.business_group_id%TYPE
2397: ,p_organization_id per_assignments_f.organization_id%TYPE
2398: ,p_effective_date DATE
2399: ,p_start_date DATE
2400: ,p_end_date DATE

Line 2397: ,p_organization_id per_assignments_f.organization_id%TYPE

2393: --************************************************************************
2394: IS
2395: --
2396: CURSOR lcu_emp_assignment_det_r ( p_business_group_id per_assignments_f.business_group_id%TYPE
2397: ,p_organization_id per_assignments_f.organization_id%TYPE
2398: ,p_effective_date DATE
2399: ,p_start_date DATE
2400: ,p_end_date DATE
2401: )

Line 2407: ,per_assignments_f PAF

2403: SELECT PAF.assignment_id
2404: ,PPS.actual_termination_date
2405: ,PPS.projected_termination_date
2406: FROM per_people_f PPF
2407: ,per_assignments_f PAF
2408: ,per_periods_of_service PPS
2409: ,pay_population_ranges PPR
2410: ,pay_payroll_actions PPA
2411: WHERE PPF.person_id = PAF.person_id

Line 2432: ,p_business_group_id per_assignments_f.business_group_id%TYPE

2428: ORDER BY PAF.assignment_id;
2429: --
2430: CURSOR lcu_emp_assignment_det ( p_start_person_id per_all_people_f.person_id%TYPE
2431: ,p_end_person_id per_all_people_f.person_id%TYPE
2432: ,p_business_group_id per_assignments_f.business_group_id%TYPE
2433: ,p_organization_id per_assignments_f.organization_id%TYPE
2434: ,p_effective_date DATE
2435: ,p_start_date DATE
2436: ,p_end_date DATE

Line 2433: ,p_organization_id per_assignments_f.organization_id%TYPE

2429: --
2430: CURSOR lcu_emp_assignment_det ( p_start_person_id per_all_people_f.person_id%TYPE
2431: ,p_end_person_id per_all_people_f.person_id%TYPE
2432: ,p_business_group_id per_assignments_f.business_group_id%TYPE
2433: ,p_organization_id per_assignments_f.organization_id%TYPE
2434: ,p_effective_date DATE
2435: ,p_start_date DATE
2436: ,p_end_date DATE
2437: )

Line 2443: ,per_assignments_f PAF

2439: SELECT PAF.assignment_id
2440: ,PPS.actual_termination_date
2441: ,PPS.projected_termination_date
2442: FROM per_people_f PPF
2443: ,per_assignments_f PAF
2444: ,per_periods_of_service PPS
2445: WHERE PPF.person_id = PAF.person_id
2446: AND PPF.person_id = PPS.person_id
2447: AND PAF.business_group_id = p_business_group_id

Line 2679: , per_assignments_f PAF

2675: , PAF.payroll_id PAYROLL_ID
2676: , PPOS.date_start HIRE_DATE
2677: , PPOS.last_standard_process_date LAST_STD_PROCESS_DATE
2678: FROM per_people_f PPF
2679: , per_assignments_f PAF
2680: , per_addresses PAD
2681: , per_periods_of_service PPOS
2682: WHERE PAF.person_id = PPF.person_id
2683: AND PAD.person_id(+) = PPF.person_id