APPS.PAY_MULTIASG dependencies on PER_ASSIGNMENTS_F

Line 82: FROM per_assignments_f ASG1,

78: AND effective_end_date;
79:
80: CURSOR other_assignments IS
81: SELECT DISTINCT ASG1.assignment_id
82: FROM per_assignments_f ASG1,
83: per_assignments_f ASG,
84: hr_soft_coding_keyflex SK
85: WHERE ASG.assignment_id = p_asst_id
86: AND ASG.payroll_id = p_payroll_id

Line 83: per_assignments_f ASG,

79:
80: CURSOR other_assignments IS
81: SELECT DISTINCT ASG1.assignment_id
82: FROM per_assignments_f ASG1,
83: per_assignments_f ASG,
84: hr_soft_coding_keyflex SK
85: WHERE ASG.assignment_id = p_asst_id
86: AND ASG.payroll_id = p_payroll_id
87: AND ASG.person_id = ASG1.person_id

Line 156: per_assignments_f ASSIGN

152: CURSOR work_schedule (p_assign_id NUMBER) IS
153: SELECT target.SEGMENT4
154: FROM
155: hr_soft_coding_keyflex target,
156: per_assignments_f ASSIGN
157: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date
158: AND ASSIGN.effective_end_date
159: AND ASSIGN.assignment_id = p_assign_id
160: AND target.soft_coding_keyflex_id = ASSIGN.soft_coding_keyflex_id

Line 280: per_assignments_f ASSIGN

276:
277: CURSOR salary_basis_code (p_assign_id NUMBER) IS
278: SELECT BASES.pay_basis
279: FROM
280: per_assignments_f ASSIGN
281: , per_pay_bases BASES
282: , pay_input_values_f INPUTV
283: , pay_element_types_f ETYPE
284: , pay_rates RATE

Line 320: per_assignments_f ASSIGN

316:
317: CURSOR salary_element (p_assign_id NUMBER) IS
318: SELECT ETYPE.element_name
319: FROM
320: per_assignments_f ASSIGN
321: , per_pay_bases BASES
322: , pay_input_values_f INPUTV
323: , pay_element_types_f ETYPE
324: , pay_rates RATE

Line 348: per_assignments_f ASSIGN

344:
345: CURSOR asg_salary (p_assign_id NUMBER) IS
346: SELECT fnd_number.canonical_to_number (EEV.screen_entry_value)
347: FROM
348: per_assignments_f ASSIGN
349: , per_pay_bases BASES
350: , pay_element_entries_f EE
351: , pay_element_entry_values_f EEV
352: WHERE p_date_earned BETWEEN ASSIGN.effective_start_date