APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 397: FROM pay_element_entry_values_f peev

393: AND pee.effective_start_date <= g_fin_end_date
394: AND pee.effective_end_date >= g_fin_start_date
395: AND pee.assignment_id = paf1.assignment_id
396: AND EXISTS (SELECT ''
397: FROM pay_element_entry_values_f peev
398: ,hr_organization_information hoi
399: WHERE peev.input_value_id = g_input_table_rec(1).input_value_id
400: AND peev.element_entry_id = pee.element_entry_id
401: AND peev.screen_entry_value = hoi.org_information3

Line 524: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,

520:
521: TYPE t_challan_entry_asg_rec IS RECORD
522: (Payment_date hr_organization_information.org_information2%TYPE,
523: Bank hr_organization_information.org_information4%TYPE,
524: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
525: tax hr_organization_information.org_information4%TYPE,
526: remarks hr_organization_information.org_information4%TYPE,
527: surcharge hr_organization_information.org_information4%TYPE,
528: cess hr_organization_information.org_information4%TYPE,

Line 2173: FROM pay_element_entry_values_f peev

2169: AND pee.effective_start_date <= g_fin_end_date
2170: AND pee.effective_end_date >= g_fin_start_date
2171: AND pee.assignment_id = p_assignment_id
2172: AND EXISTS (SELECT ''
2173: FROM pay_element_entry_values_f peev
2174: ,hr_organization_information hoi
2175: WHERE peev.input_value_id = g_input_table_rec(1).input_value_id
2176: AND peev.element_entry_id = pee.element_entry_id
2177: AND peev.screen_entry_value = hoi.org_information3

Line 2235: FROM pay_element_entry_values_f peev

2231: CURSOR csr_get_element_entry_value(p_element_entry_id NUMBER)
2232: IS
2233: SELECT peev.screen_entry_value entry_value
2234: ,piv.display_sequence indx
2235: FROM pay_element_entry_values_f peev
2236: ,pay_input_values_f piv
2237: WHERE peev.element_entry_id = p_element_entry_id
2238: AND peev.input_value_id IN(g_input_table_rec(1).input_value_id
2239: ,g_input_table_rec(2).input_value_id

Line 2259: (screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE);

2255: TYPE t_challan_entry_asg_tab_type is table of t_challan_entry_asg_rec index by binary_integer;
2256: t_challan_entry_asg_tab t_challan_entry_asg_tab_type;
2257:
2258: TYPE t_entry_values_rec IS RECORD
2259: (screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE);
2260:
2261: TYPE t_entry_values_tab_type is table of t_entry_values_rec index by binary_integer;
2262: t_entry_values_tab t_entry_values_tab_type;
2263: