APPS.PQP_GB_PSI_BON_HISTORY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 375: FROM pay_element_entry_values_f

371: p_ele_entry_value_id NUMBER
372: )
373: IS
374: SELECT element_entry_id
375: FROM pay_element_entry_values_f
376: WHERE element_entry_value_id = p_ele_entry_value_id
377: AND ROWNUM = 1;
378: BEGIN
379: debug_enter(l_proc);

Line 415: -- for correction events on pay_element_entry_values_f

411: IF g_current_layout = 'PERIODIC' THEN
412: g_curr_element_entry_id := fnd_number.canonical_to_number(l_chg_surrogate_key);
413:
414: IF l_chg_type = 'C' THEN
415: -- for correction events on pay_element_entry_values_f
416: -- the surrogate key is element_entry_value_id
417: -- this should be re-set to element_entry_id
418: debug('element_entry_value_id: '||g_curr_element_entry_id,20);
419: -- For Bug 9503728

Line 420: IF l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F'

416: -- the surrogate key is element_entry_value_id
417: -- this should be re-set to element_entry_id
418: debug('element_entry_value_id: '||g_curr_element_entry_id,20);
419: -- For Bug 9503728
420: IF l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F'
421: THEN
422: OPEN csr_get_ee_id(g_curr_element_entry_id);
423: FETCH csr_get_ee_id INTO g_curr_element_entry_id;
424: CLOSE csr_get_ee_id;

Line 934: FROM pay_element_entry_values_f peev

930:
931: CURSOR csr_get_claim_date
932: IS
933: SELECT peev.screen_entry_value
934: FROM pay_element_entry_values_f peev
935: ,pay_input_values_f piv
936: WHERE peev.element_entry_id = g_curr_element_entry_id
937: AND peev.input_value_id = piv.input_value_id
938: AND UPPER(piv.NAME) = 'CLAIM DATE'