DBA Data[Home] [Help]

APPS.PAY_DK_TC_DP_UPLOAD dependencies on PAY_ELEMENT_ENTRIES_F

Line 63: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;

59: -- Variables to Read from File
60: l_cpr VARCHAR2(80);
61: l_employer_org_no VARCHAR2(80);
62: l_effective_date VARCHAR2(80);
63: l_element_entry_id pay_element_entries_f.element_entry_id%TYPE;
64: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
65: l_element_name pay_element_types_f.element_name%TYPE;
66: -- Added for Flugger fix
67: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;

Line 68: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

64: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
65: l_element_name pay_element_types_f.element_name%TYPE;
66: -- Added for Flugger fix
67: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;
68: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
69: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
70: l_input_value_name1 VARCHAR2(80);
71: l_input_value_name2 VARCHAR2(80);
72: l_input_value_name3 VARCHAR2(80);

Line 69: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

65: l_element_name pay_element_types_f.element_name%TYPE;
66: -- Added for Flugger fix
67: l_element_name_tl PAY_ELEMENT_TYPES_F_TL.element_name%TYPE;
68: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
69: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
70: l_input_value_name1 VARCHAR2(80);
71: l_input_value_name2 VARCHAR2(80);
72: l_input_value_name3 VARCHAR2(80);
73: l_input_value_name4 VARCHAR2(80);

Line 148: from pay_element_entries_f pee

144:
145: CURSOR csr_get_element_details(p_assignment_id per_all_assignments_f.assignment_id%TYPE, p_date per_all_assignments_f.effective_start_date%TYPE)
146: IS
147: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
148: from pay_element_entries_f pee
149: , pay_element_types_f pet
150: , pay_element_links_f pel
151: , per_all_assignments_f paa
152: where pet.ELEMENT_NAME = 'Tax Card'