APPS.PQP_TIAALOD_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

6: l_business_group_id pay_payroll_actions.business_group_id%TYPE;
7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
8: l_effective_date pay_payroll_actions.effective_date%TYPE;
9: l_action_type pay_payroll_actions.action_type%TYPE;
10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
12: l_tax_unit_id hr_organization_units.organization_id%TYPE;
13: l_gre_name hr_organization_units.name%TYPE;
14: l_organization_id hr_organization_units.organization_id%TYPE;

Line 11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;

7: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
8: l_effective_date pay_payroll_actions.effective_date%TYPE;
9: l_action_type pay_payroll_actions.action_type%TYPE;
10: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
11: l_assignment_id pay_assignment_actions.assignment_id%TYPE;
12: l_tax_unit_id hr_organization_units.organization_id%TYPE;
13: l_gre_name hr_organization_units.name%TYPE;
14: l_organization_id hr_organization_units.organization_id%TYPE;
15: l_org_name hr_organization_units.name%TYPE;

Line 18: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

14: l_organization_id hr_organization_units.organization_id%TYPE;
15: l_org_name hr_organization_units.name%TYPE;
16: l_location_id hr_locations.location_id%TYPE;
17: l_location_code hr_locations.location_code%TYPE;
18: l_ppp_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
19: l_bal_value NUMBER(11,2);
20: l_leg_param VARCHAR2(240);
21: l_leg_start_date DATE;
22: l_leg_end_date DATE;

Line 55: tax_unit_id pay_assignment_actions.tax_unit_id%TYPE);

51:
52: pay_mode_t t_pay_mode;
53:
54: TYPE r_org_ppg IS RECORD (org_ppg_code hr_organization_information.org_information1%TYPE,
55: tax_unit_id pay_assignment_actions.tax_unit_id%TYPE);
56:
57: TYPE t_org_ppg IS TABLE OF r_org_ppg INDEX BY BINARY_INTEGER;
58: org_ppg_t t_org_ppg;
59:

Line 89: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,

85: balance_value6 NUMBER,
86: input_date per_assignments_f.effective_end_date%TYPE,
87: input_start_date per_assignments_f.effective_end_date%TYPE,
88: assignment_id per_assignments_f.assignment_id%TYPE,
89: assignment_action_id pay_assignment_actions.assignment_action_id%TYPE,
90: err_num VARCHAR2(800),
91: err_msg VARCHAR2(800),
92: payroll_id NUMBER
93: );

Line 783: pay_assignment_actions paa,

779: hr_organization_units hox,
780: hr_organization_units hou,
781: per_assignments_f paf,
782: pay_payroll_actions ppa,
783: pay_assignment_actions paa,
784: pay_action_interlocks pai,
785: pay_assignment_actions paa_gen,
786: pay_payroll_actions ppa_gen
787: WHERE

Line 785: pay_assignment_actions paa_gen,

781: per_assignments_f paf,
782: pay_payroll_actions ppa,
783: pay_assignment_actions paa,
784: pay_action_interlocks pai,
785: pay_assignment_actions paa_gen,
786: pay_payroll_actions ppa_gen
787: WHERE
788: ppa_gen.payroll_action_id = l_pactid
789: AND paa_gen.payroll_action_id = ppa_gen.payroll_action_id

Line 815: l_prev_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

811: AND hou.organization_id = paa.tax_unit_id
812: ORDER BY paa.assignment_id,ppa.payroll_id, paa.assignment_action_id;
813:
814: l_prev_assignment_id per_all_assignments_f.assignment_id%TYPE := NULL;
815: l_prev_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
816: l_prev_end_date date;
817: l_count NUMBER(5);
818: l_proc_name VARCHAR2(150) := g_proc_name ||'load_data';
819: