APPS.PAY_GB_MOVDED_EDI dependencies on PAY_ELEMENT_TYPES_F

Line 810: from pay_element_types_f

806: l_asg_end date;
807:
808: cursor csr_element_id(p_name varchar2) is
809: select element_type_id
810: from pay_element_types_f
811: where element_name = p_name
812: and legislation_code = 'GB';
813:
814: cursor csr_assignment_details is

Line 1243: from pay_element_types_f elt,

1239: cursor csr_student_loan is
1240: select nvl(min(decode(inv.name, 'Start Date', eev.screen_entry_value, 'X')),'X') s_date,
1241: nvl(min(decode(inv.name, 'End Date', eev.screen_entry_value, null)),'4712/12/31 00:00:00') e_date,
1242: 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
1243: from pay_element_types_f elt,
1244: pay_element_entries_f ele,
1245: pay_input_values_f inv,
1246: pay_element_entry_values_f eev
1247: where elt.element_name = 'Student Loan'