APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ELEMENT_TYPES_F

Line 620: from pay_element_types_f

616: l_asg_end date;
617:
618: cursor csr_element_id(p_name varchar2) is
619: select element_type_id
620: from pay_element_types_f
621: where element_name = p_name
622: and legislation_code = 'GB';
623:
624: cursor csr_assignment_details is

Line 1042: from pay_element_types_f elt,

1038: cursor csr_student_loan is
1039: select nvl(min(decode(inv.name, 'Start Date', eev.screen_entry_value, 'X')),'X') s_date,
1040: nvl(min(decode(inv.name, 'End Date', eev.screen_entry_value, null)),'4712/12/31 00:00:00') e_date,
1041: fnd_date.date_to_canonical(min(decode(inv.name, 'End Date', eev.effective_end_date, fnd_date.canonical_to_date('4712/12/31 00:00:00')))) eff_date
1042: from pay_element_types_f elt,
1043: pay_element_entries_f ele,
1044: pay_input_values_f inv,
1045: pay_element_entry_values_f eev
1046: where elt.element_name = 'Student Loan'