APPS.PAY_NO_EMP_CONT_2007 dependencies on PAY_ASSIGNMENT_ACTIONS

Line 97: cursor csr_assignment_id (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE

93:
94:
95:
96: -- Cursor to get the assignment_action_id and assignment_id
97: cursor csr_assignment_id (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
98: ,l_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type) is
99: select ASSIGNMENT_ID
100: ,ASSIGNMENT_ACTION_ID
101: from pay_assignment_actions

Line 101: from pay_assignment_actions

97: cursor csr_assignment_id (p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE
98: ,l_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type) is
99: select ASSIGNMENT_ID
100: ,ASSIGNMENT_ACTION_ID
101: from pay_assignment_actions
102: where PAYROLL_ACTION_ID = l_payroll_action_id
103: and TAX_UNIT_ID = p_tax_unit_id;
104:
105: -- Cursor to get the Local Unit and Tax Municipality

Line 108: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type

104:
105: -- Cursor to get the Local Unit and Tax Municipality
106:
107: cursor csr_lu_mu (l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type
108: ,l_assignment_action_id pay_assignment_actions.ASSIGNMENT_ACTION_ID %type
109: ,p_date_earned DATE
110: ,l_ele_type_id NUMBER ) is
111: SELECT scl.segment2 local_unit_id
112: ,rr.jurisdiction_code tax_mun_id

Line 113: FROM pay_assignment_actions assact

109: ,p_date_earned DATE
110: ,l_ele_type_id NUMBER ) is
111: SELECT scl.segment2 local_unit_id
112: ,rr.jurisdiction_code tax_mun_id
113: FROM pay_assignment_actions assact
114: ,per_all_assignments_f asg
115: ,hr_soft_coding_keyflex scl
116: ,pay_run_results rr
117: WHERE assact.assignment_action_id = l_assignment_action_id

Line 134: FROM pay_assignment_actions assact

130: (p_payroll_action_id pay_payroll_actions.PAYROLL_ACTION_ID%type
131: ,p_date_earned DATE ) is
132:
133: SELECT scl.segment2 loc_unit , assact.tax_unit_id leg_emp
134: FROM pay_assignment_actions assact
135: ,pay_run_types_f prt
136: ,per_all_assignments_f asg
137: ,hr_soft_coding_keyflex scl
138: WHERE assact.PAYROLL_ACTION_ID = p_payroll_action_id

Line 159: cursor get_le_status(p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE) IS

155: AND BUSINESS_GROUP_ID = p_bus_group_id ;
156:
157:
158: -- cursor to get STATUS from Legal Employer
159: cursor get_le_status(p_tax_unit_id pay_assignment_actions.TAX_UNIT_ID%TYPE) IS
160: select ORG_INFORMATION3
161: from HR_ORGANIZATION_INFORMATION
162: where ORGANIZATION_ID = p_tax_unit_id
163: and org_information_context = 'NO_LEGAL_EMPLOYER_DETAILS';