APPS.PAY_DK_SICKPAY_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 39: FROM per_all_assignments_f asg

35:
36:
37: CURSOR csr_get_details(p_period_start_date DATE,p_period_end_date DATE,p_assignment_id NUMBER,p_input_value VARCHAR2) is
38: SELECT eev.screen_entry_value screen_entry_value
39: FROM per_all_assignments_f asg
40: ,per_all_people_f per
41: ,pay_element_links_f el
42: ,pay_element_types_f et
43: ,pay_input_values_f iv

Line 181: FROM per_all_assignments_f asg1

177: CURSOR get_details(p_assignment_id NUMBER , p_effective_date DATE ) IS
178: SELECT ee.element_entry_id element_entry_id
179: , eev1.screen_entry_value screen_entry_value
180: , iv1.name
181: FROM per_all_assignments_f asg1
182: ,per_all_assignments_f asg2
183: ,per_all_people_f per
184: ,pay_element_links_f el
185: ,pay_element_types_f et

Line 182: ,per_all_assignments_f asg2

178: SELECT ee.element_entry_id element_entry_id
179: , eev1.screen_entry_value screen_entry_value
180: , iv1.name
181: FROM per_all_assignments_f asg1
182: ,per_all_assignments_f asg2
183: ,per_all_people_f per
184: ,pay_element_links_f el
185: ,pay_element_types_f et
186: ,pay_input_values_f iv1

Line 346: per_all_assignments_f paaf

342: CURSOR csr_section28 IS
343: SELECT
344: NVL(hsck.segment18,'N')
345: FROM
346: per_all_assignments_f paaf
347: ,hr_soft_coding_keyflex hsck
348: WHERE
349: paaf.assignment_id = p_assignment_id
350: AND p_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date

Line 398: FROM per_all_assignments_f asg

394:
395:
396: CURSOR csr_get_details(p_period_start_date DATE,p_period_end_date DATE,p_assignment_id NUMBER,p_input_value VARCHAR2) is
397: SELECT eev.screen_entry_value screen_entry_value
398: FROM per_all_assignments_f asg
399: ,per_all_people_f per
400: ,pay_element_links_f el
401: ,pay_element_types_f et
402: ,pay_input_values_f iv