APPS.PAY_NO_EMP_CONT_2007 dependencies on PER_ALL_ASSIGNMENTS_F

Line 107: cursor csr_lu_mu (l_assignment_id per_all_assignments_f.ASSIGNMENT_ID%type

103: and TAX_UNIT_ID = p_tax_unit_id;
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

Line 114: ,per_all_assignments_f asg

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
118: AND assact.assignment_id = asg.assignment_id

Line 136: ,per_all_assignments_f asg

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
139: and prt.LEGISLATION_CODE = 'NO'
140: and prt.RUN_TYPE_NAME = 'Employer Contributions'