APPS.PAY_IN_SOE_PKG dependencies on PER_ASSIGNMENTS_F

Line 29: FROM per_assignments_f peaf

25:
26: CURSOR csr_reg_legal_name
27: IS
28: SELECT hoi2.org_information4
29: FROM per_assignments_f peaf
30: ,hr_soft_coding_keyflex hrscf
31: ,hr_organization_information hoi
32: ,hr_organization_units hou
33: ,hr_organization_information hoi2

Line 797: , per_assignments_f paf

793: CURSOR csr_get_tax_unit_id
794: IS
795: SELECT hsck.segment1
796: FROM hr_soft_coding_keyflex hsck
797: , per_assignments_f paf
798: , pay_assignment_actions paa
799: , pay_payroll_actions ppa
800: WHERE hsck.soft_coding_keyflex_id = paf.soft_coding_keyflex_id
801: AND paa.assignment_action_id = p_assignment_action_id

Line 907: l_assignment_id per_assignments_f.assignment_id%TYPE;

903: l_uom pay_accrual_plans.accrual_units_of_measure%TYPE;
904: l_payroll_id pay_payrolls_f.payroll_id%TYPE;
905: l_business_group_id per_business_groups.business_group_id%TYPE;
906: l_accrual_plan_id pay_accrual_plans.accrual_plan_id%TYPE;
907: l_assignment_id per_assignments_f.assignment_id%TYPE;
908: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
909: l_annual_leave_balance NUMBER;
910: l_ovn NUMBER;
911: l_leave_taken NUMBER;