APPS.PAY_FR_RULES dependencies on PAY_ASSIGNMENT_ACTIONS

Line 31: estab_id pay_assignment_actions.tax_unit_id%TYPE,

27: --
28: --
29: -- private globals used for caching in get_dynamic_org_meth
30: TYPE g_org_meth_map_rec IS RECORD (
31: estab_id pay_assignment_actions.tax_unit_id%TYPE,
32: gen_org_paymeth_id pay_org_payment_methods_f.ORG_PAYMENT_METHOD_ID%TYPE,
33: new_org_paymeth_id pay_org_payment_methods_f.ORG_PAYMENT_METHOD_ID%TYPE,
34: err_name fnd_new_messages.MESSAGE_NAME%TYPE,
35: opm_name_token varchar2(80),

Line 41: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;

37: org_type_token varchar2(20));
38: TYPE g_org_meth_map_typ IS TABLE OF g_org_meth_map_rec
39: Index by BINARY_INTEGER;
40: g_org_meth_map_tbl g_org_meth_map_typ;
41: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
42: g_estab_id pay_assignment_actions.tax_unit_id%TYPE;
43: -- end of private globals used for caching in get_dynamic_org_meth
44:
45:

Line 42: g_estab_id pay_assignment_actions.tax_unit_id%TYPE;

38: TYPE g_org_meth_map_typ IS TABLE OF g_org_meth_map_rec
39: Index by BINARY_INTEGER;
40: g_org_meth_map_tbl g_org_meth_map_typ;
41: g_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE;
42: g_estab_id pay_assignment_actions.tax_unit_id%TYPE;
43: -- end of private globals used for caching in get_dynamic_org_meth
44:
45:
46: procedure raise_null_context_input(p_ee_id number,p_cxt_name varchar2)

Line 98: pay_assignment_actions aa,

94: -- element entry
95:
96: cursor csr_process_type_entry_value is
97: select SCREEN_ENTRY_VALUE from
98: pay_assignment_actions aa,
99: pay_payroll_actions pa,
100: pay_element_entries_f ee,
101: pay_element_entry_values_f eev,
102: pay_input_values_f iv,

Line 200: from pay_assignment_actions

196: l_company_id hr_all_organization_units.ORGANIZATION_ID%TYPE;
197: --
198: cursor csr_get_estab is
199: select tax_unit_id
200: from pay_assignment_actions
201: where assignment_action_id = p_assignment_action_id;
202: --
203: cursor csr_get_company is
204: select fnd_number.canonical_to_number(hoi.ORG_INFORMATION1)