APPS.PAY_IN_24Q_ARCHIVE dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 396: FROM pay_element_entry_values_f peev

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

Line 542: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,

538:
539: TYPE t_challan_entry_asg_rec IS RECORD
540: (Payment_date hr_organization_information.org_information2%TYPE,
541: Bank hr_organization_information.org_information4%TYPE,
542: challan_number pay_element_entry_values_f.screen_entry_value%TYPE,
543: tax hr_organization_information.org_information4%TYPE,
544: remarks hr_organization_information.org_information4%TYPE,
545: surcharge hr_organization_information.org_information4%TYPE,
546: cess hr_organization_information.org_information4%TYPE,

Line 2279: FROM pay_element_entry_values_f peev

2275: AND pee.effective_start_date <= g_fin_end_date
2276: AND pee.effective_end_date >= g_fin_start_date
2277: AND pee.assignment_id = p_assignment_id
2278: AND EXISTS (SELECT ''
2279: FROM pay_element_entry_values_f peev
2280: ,hr_organization_information hoi
2281: WHERE peev.input_value_id = g_input_table_rec(1).input_value_id
2282: AND peev.element_entry_id = pee.element_entry_id
2283: AND peev.screen_entry_value LIKE '% - '|| hoi.org_information3|| ' - %'||to_char(fnd_date.canonical_to_date(hoi.org_information2),'DD-Mon-RRRR')

Line 2341: FROM pay_element_entry_values_f peev

2337: CURSOR csr_get_element_entry_value(p_element_entry_id NUMBER)
2338: IS
2339: SELECT peev.screen_entry_value entry_value
2340: ,piv.display_sequence indx
2341: FROM pay_element_entry_values_f peev
2342: ,pay_input_values_f piv
2343: WHERE peev.element_entry_id = p_element_entry_id
2344: AND peev.input_value_id IN(g_input_table_rec(1).input_value_id
2345: ,g_input_table_rec(2).input_value_id

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

2361: TYPE t_challan_entry_asg_tab_type is table of t_challan_entry_asg_rec index by binary_integer;
2362: t_challan_entry_asg_tab t_challan_entry_asg_tab_type;
2363:
2364: TYPE t_entry_values_rec IS RECORD
2365: (screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE);
2366:
2367: TYPE t_entry_values_tab_type is table of t_entry_values_rec index by binary_integer;
2368: t_entry_values_tab t_entry_values_tab_type;
2369: