APPS.PAY_SA_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 8: estab_id pay_assignment_actions.tax_unit_id%TYPE,

4: --
5: --
6: -- private globals used for caching in get_dynamic_org_meth
7: TYPE g_org_meth_map_rec IS RECORD (
8: estab_id pay_assignment_actions.tax_unit_id%TYPE,
9: gen_org_paymeth_id pay_org_payment_methods_f.ORG_PAYMENT_METHOD_ID%TYPE,
10: new_org_paymeth_id pay_org_payment_methods_f.ORG_PAYMENT_METHOD_ID%TYPE,
11: err_name fnd_new_messages.MESSAGE_NAME%TYPE,
12: opm_name_token varchar2(80),

Line 18: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

14: org_type_token varchar2(20));
15: TYPE g_org_meth_map_typ IS TABLE OF g_org_meth_map_rec
16: Index by BINARY_INTEGER;
17: g_org_meth_map_tbl g_org_meth_map_typ;
18: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
19: g_estab_id pay_assignment_actions.tax_unit_id%TYPE;
20: -- end of private globals used for caching in get_dynamic_org_meth
21:
22:

Line 19: g_estab_id pay_assignment_actions.tax_unit_id%TYPE;

15: TYPE g_org_meth_map_typ IS TABLE OF g_org_meth_map_rec
16: Index by BINARY_INTEGER;
17: g_org_meth_map_tbl g_org_meth_map_typ;
18: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
19: g_estab_id pay_assignment_actions.tax_unit_id%TYPE;
20: -- end of private globals used for caching in get_dynamic_org_meth
21:
22:
23: procedure get_source_text_context

Line 34: from pay_assignment_actions aa

30: hr_utility.set_location('PAY_SA_RULES.get_source_text_context',1);
31: begin
32: select 'Y'
33: into l_joiner
34: from pay_assignment_actions aa
35: ,pay_payroll_actions pa
36: ,per_all_assignments_f asg
37: ,per_periods_of_service pos
38: where aa.assignment_action_id = p_asg_act_id

Line 67: from pay_assignment_actions aa

63: hr_utility.set_location('PAY_SA_RULES.get_source_text_context',1);
64: begin
65: select 'Y'
66: into l_leaver
67: from pay_assignment_actions aa
68: ,pay_payroll_actions pa
69: ,per_all_assignments_f asg
70: ,per_periods_of_service POS
71: where aa.assignment_action_id = p_asg_act_id

Line 99: from pay_assignment_actions aa

95: begin
96: begin
97: select nationality
98: into l_nationality_cd
99: from pay_assignment_actions aa
100: ,pay_payroll_actions pa
101: ,per_all_assignments_f asg
102: ,per_all_people_f per
103: where aa.assignment_action_id = p_asg_act_id