DBA Data[Home] [Help]

APPS.PAY_FI_TC_DP_UPLOAD dependencies on PAY_ELEMENT_ENTRIES_F

Line 72: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

68: l_ni VARCHAR2(80);
69: l_row_count NUMBER;
70: l_employer_org_no VARCHAR2(80);
71: l_employment_type VARCHAR2(80);
72: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
73: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
74: l_element_name pay_element_types_f.element_name%TYPE;
75: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
76: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

Line 75: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

71: l_employment_type VARCHAR2(80);
72: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
73: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
74: l_element_name pay_element_types_f.element_name%TYPE;
75: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
76: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
77: l_input_value_name1 VARCHAR2(80);
78: l_input_value_name2 VARCHAR2(80);
79: l_input_value_name3 VARCHAR2(80);

Line 76: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

72: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
73: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
74: l_element_name pay_element_types_f.element_name%TYPE;
75: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
76: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
77: l_input_value_name1 VARCHAR2(80);
78: l_input_value_name2 VARCHAR2(80);
79: l_input_value_name3 VARCHAR2(80);
80: l_input_value_name4 VARCHAR2(80);

Line 225: from pay_element_entries_f pee

221: (p_assignment_id per_all_assignments_f.assignment_id%TYPE
222: ,p_element_name pay_element_types_f.ELEMENT_NAME%TYPE)
223: IS
224: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
225: from pay_element_entries_f pee
226: , pay_element_types_f pet
227: , pay_element_links_f pel
228: , per_all_assignments_f paa
229: where pet.ELEMENT_NAME = p_element_name