APPS.PQP_GB_PSI_STH_HISTORY dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 993: FROM pay_element_entry_values_f peev

989: )
990: IS
991: SELECT piv.NAME
992: ,peev.screen_entry_value
993: FROM pay_element_entry_values_f peev
994: ,pay_input_values_f piv
995: WHERE peev.element_entry_id = p_element_entry_id
996: AND peev.input_value_id = piv.input_value_id
997: AND UPPER(piv.NAME) IN ('CLAIM DATE','ADJUSTED HOURS')

Line 1019: FROM pay_element_entry_values_f

1015: p_ele_entry_value_id NUMBER
1016: )
1017: IS
1018: SELECT element_entry_id
1019: FROM pay_element_entry_values_f
1020: WHERE element_entry_value_id = p_ele_entry_value_id
1021: AND ROWNUM = 1;
1022:
1023: BEGIN

Line 1046: -- for correction events on pay_element_entry_values_f

1042:
1043: g_curr_element_entry_id := fnd_number.canonical_to_number(l_chg_surrogate_key);
1044:
1045: IF l_chg_type = 'C' THEN
1046: -- for correction events on pay_element_entry_values_f
1047: -- the surrogate key is element_entry_value_id
1048: -- this should be re-set to element_entry_id
1049: debug('element_entry_value_id: '||g_curr_element_entry_id,20);
1050: OPEN csr_get_ee_id(g_curr_element_entry_id);