APPS.PAY_US_SIMULATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 52: FROM per_all_assignments_f paf

48: CURSOR get_organization_id(cp_assignment_id NUMBER,
49: cp_effective_date DATE)
50: IS
51: SELECT paf.organization_id
52: FROM per_all_assignments_f paf
53: WHERE paf.assignment_id = cp_assignment_id
54: AND cp_effective_date BETWEEN paf.effective_start_date
55: AND paf.effective_end_date;
56:

Line 67: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;

63: AND org.organization_id = cp_organization_id;
64:
65: lv_procedure_name VARCHAR2(100) := '.add_custom_xml';
66:
67: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
68: ln_tax_unit_id hr_all_organization_units.organization_id%TYPE;
69: ld_effective_date DATE;
70: ln_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
71: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

Line 71: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;

67: ln_business_group_id per_all_assignments_f.business_group_id%TYPE;
68: ln_tax_unit_id hr_all_organization_units.organization_id%TYPE;
69: ld_effective_date DATE;
70: ln_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
71: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
72: ln_organization_id hr_all_organization_units.organization_id%TYPE;
73:
74: lv_employer_address1 pay_action_information.action_information1%TYPE;
75: lv_employer_address2 pay_action_information.action_information1%TYPE;