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 183: FROM per_all_assignments_f asg1

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

Line 184: ,per_all_assignments_f asg2

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

Line 348: per_all_assignments_f paaf

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

Line 400: FROM per_all_assignments_f asg

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