APPS.PQP_GB_PSI_FUNCTIONS dependencies on PAY_ELEMENT_ENTRY_VALUES_F

Line 6493: FROM PAY_ELEMENT_ENTRY_VALUES_F

6489: (p_element_entry_value_id IN NUMBER
6490: )
6491: IS
6492: SELECT element_entry_id
6493: FROM PAY_ELEMENT_ENTRY_VALUES_F
6494: WHERE element_entry_value_id =p_element_entry_value_id
6495: AND ROWNUM=1;
6496:
6497:

Line 6557: AND l_chg_table <> 'PAY_ELEMENT_ENTRY_VALUES_F'

6553:
6554:
6555:
6556: IF l_chg_table <> 'PAY_ELEMENT_ENTRIES_F'
6557: AND l_chg_table <> 'PAY_ELEMENT_ENTRY_VALUES_F'
6558: -- OR (l_chg_table = 'PAY_ELEMENT_ENTRIES_F' AND l_chg_type = 'E')
6559: THEN
6560: l_chg_of_element_yn := 'N'; -- event not of element type
6561: ELSE

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

6639: END IF;
6640:
6641:
6642: -- if correction, implies that it is on screen entry value
6643: -- on pay_element_entry_values_f and the surrogate key is
6644: -- not element_entry_id, but rather element_entry_value_id
6645: IF l_chg_type = 'C'
6646: THEN
6647: debug('correction event');

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

7083: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7084: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))
7085: OR (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7086: AND l_chg_type <> 'E')
7087: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN
7088:
7089: g_sal_chg_event_exists := 'Y';
7090:
7091: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'

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

7274: ELSIF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7275: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS') OR l_update_type = 'I'))
7276: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7277: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_update_type = 'I'))
7278: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F') THEN
7279:
7280: l_other_event_exist := 'Y';
7281:
7282: ELSIF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'

Line 7436: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F')

7432: --For Bug 5998108: Added new column EMPLOYMENT_CATEGORY
7433: --For bug 7013325: Added new column l_configured_dff_segment
7434: IF (l_chg_table = 'PAY_ELEMENT_ENTRIES_F'
7435: AND l_chg_type <> 'E')
7436: OR (l_chg_table = 'PAY_ELEMENT_ENTRY_VALUES_F')
7437: OR (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7438: AND (l_chg_column_name IN ('GRADE_ID','NORMAL_HOURS','EMPLOYMENT_CATEGORY',l_configured_dff_segment) OR l_chg_type = 'I'))
7439: OR (l_chg_table = 'PQP_ASSIGNMENT_ATTRIBUTES_F'
7440: AND (l_chg_column_name = 'CONTRACT_TYPE' OR l_chg_type = 'I'))THEN