APPS.PQP_GB_PSI_FUNCTIONS dependencies on PER_ASSIGNMENT_BUDGET_VALUES_F

Line 7270: IF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'

7266: g_sal_chg_event_exists := 'Y';
7267:
7268: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7269:
7270: IF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
7271: AND (l_chg_column_name = 'VALUE' OR l_chg_type = 'I' )) THEN
7272:
7273: l_chg_surrogate_key := g_pay_proc_evt_tab(l_index).surrogate_key;
7274: debug('l_chg_surrogate_key: '||l_chg_surrogate_key);

Line 7367: From per_assignment_budget_values_f

7363: IS
7364: Cursor csr_get_abv_end_date(p_assignment_budget_value_id IN NUMBER)
7365: Is
7366: Select max(effective_end_date)
7367: From per_assignment_budget_values_f
7368: Where assignment_budget_value_id = p_assignment_budget_value_id;
7369:
7370: l_chg_table_id NUMBER;
7371: l_update_type VARCHAR2(10);

Line 7429: ELSIF l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'

7425: THEN
7426: debug('Found Reverse Term event');
7427: l_found_rev_term_event := 'Y';
7428: END IF;
7429: ELSIF l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
7430: AND l_chg_column_name = 'EFFECTIVE_END_DATE'
7431: AND l_update_type = 'C'
7432: THEN
7433: l_abv_end_date := NULL;

Line 7620: ELSIF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'

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'
7621: AND (l_chg_column_name = 'VALUE' OR l_update_type = 'I' )) THEN
7622:
7623: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
7624: debug('l_chg_surrogate_key: '||l_chg_surrogate_key);

Line 7816: IF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'

7812: RETURN 'Y';
7813:
7814: END IF; --IF (l_chg_table = 'PER_ALL_ASSIGNMENTS_F'
7815:
7816: IF (l_chg_table = 'PER_ASSIGNMENT_BUDGET_VALUES_F'
7817: AND (l_chg_column_name = 'VALUE' OR l_chg_type = 'I' )) THEN
7818:
7819: l_chg_surrogate_key := ben_ext_person.g_chg_surrogate_key;
7820: debug('l_chg_surrogate_key: '||l_chg_surrogate_key);

Line 8400: FROM PER_ASSIGNMENT_BUDGET_VALUES_F

8396: l_fte_value NUMBER;
8397: CURSOR csr_get_fte_value
8398: IS
8399: SELECT value
8400: FROM PER_ASSIGNMENT_BUDGET_VALUES_F
8401: WHERE assignment_id = p_assignment_id
8402: AND UNIT = 'FTE'
8403: AND p_effective_date between effective_start_date
8404: AND effective_end_date;