APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 6653: FROM PAY_ELEMENT_ENTRY_VALUES_F

6649: (p_element_entry_value_id IN NUMBER
6650: )
6651: IS
6652: SELECT element_entry_id
6653: FROM PAY_ELEMENT_ENTRY_VALUES_F
6654: WHERE element_entry_value_id =p_element_entry_value_id
6655: AND ROWNUM=1;
6656:
6657:

Line 6717: AND l_chg_table <> 'PAY_ELEMENT_ENTRY_VALUES_F'

6713:
6714:
6715:
6716: IF l_chg_table <> 'PAY_ELEMENT_ENTRIES_F'
6717: AND l_chg_table <> 'PAY_ELEMENT_ENTRY_VALUES_F'
6718: -- OR (l_chg_table = 'PAY_ELEMENT_ENTRIES_F' AND l_chg_type = 'E')
6719: THEN
6720: l_chg_of_element_yn := 'N'; -- event not of element type
6721: ELSE

Line 6803: -- on pay_element_entry_values_f and the surrogate key is

6799: END IF;
6800:
6801:
6802: -- if correction, implies that it is on screen entry value
6803: -- on pay_element_entry_values_f and the surrogate key is
6804: -- not element_entry_id, but rather element_entry_value_id
6805: IF l_chg_type = 'C'
6806: THEN
6807: debug('correction event');

Line 7264: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN

7260: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7261: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))
7262: OR (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7263: AND l_chg_type <> 'E')
7264: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN
7265:
7266: g_sal_chg_event_exists := 'Y';
7267:
7268: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

Line 7616: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN

7612: ELSIF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7613: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS') OR l_update_type = 'I'))
7614: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7615: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_update_type = 'I'))
7616: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN
7617:
7618: l_other_event_exist := 'Y';
7619:
7620: ELSIF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'

Line 7804: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F')

7800: --For Bug 5998108: Added new column EMPLOYMENT_CATEGORY
7801: --For bug 7013325: Added new column l_configured_dff_segment
7802: IF (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7803: AND l_chg_type <> 'E')
7804: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F')
7805: OR (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7806: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS','EMPLOYMENT_CATEGORY',l_configured_dff_segment) OR l_chg_type = 'I'))
7807: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7808: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))THEN