APPS.PAY_SE_TAX_CARD dependencies on PAY_ELEMENT_ENTRIES_F

Line 79: L_ELEMENT_ENTRY_ID pay_element_entries_f.element_entry_id%TYPE;

75: l_pin VARCHAR2(80);
76: l_employer_org_no VARCHAR2(80);
77:
78: L_ASSIGNMENT_ID per_all_assignments_f.assignment_id%TYPE;
79: L_ELEMENT_ENTRY_ID pay_element_entries_f.element_entry_id%TYPE;
80: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
81: L_ELEMENT_NAME pay_element_types_f.element_name%TYPE;
82:
83: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

Line 83: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;

79: L_ELEMENT_ENTRY_ID pay_element_entries_f.element_entry_id%TYPE;
80: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
81: L_ELEMENT_NAME pay_element_types_f.element_name%TYPE;
82:
83: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
84: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
85:
86: l_input_value_name1 VARCHAR2(80);
87: l_input_value_name2 VARCHAR2(80);

Line 84: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;

80: L_ELEMENT_LINK_ID pay_element_links_f.ELEMENT_LINK_ID%TYPE;
81: L_ELEMENT_NAME pay_element_types_f.element_name%TYPE;
82:
83: l_effective_start_date pay_element_entries_f.effective_start_date%TYPE;
84: l_effective_end_date pay_element_entries_f.effective_end_date%TYPE;
85:
86: l_input_value_name1 VARCHAR2(80);
87: l_input_value_name2 VARCHAR2(80);
88: l_input_value_name3 VARCHAR2(80);

Line 183: from pay_element_entries_f pee

179: p_assignment_id per_all_assignments_f.assignment_id%TYPE
180: )
181: IS
182: SELECT pee.ELEMENT_ENTRY_ID , pet.ELEMENT_NAME, pee.EFFECTIVE_START_DATE,pee.EFFECTIVE_END_DATE
183: from pay_element_entries_f pee
184: , pay_element_types_f pet
185: , pay_element_links_f pel
186: , per_all_assignments_f paa
187: where pet.ELEMENT_NAME = 'Tax Card'