APPS.PQP_GB_PSI_STH_HISTORY dependencies on PAY_ELEMENT_ENTRIES_F

Line 674: FROM PAY_ELEMENT_ENTRIES_F

670: CURSOR csr_ele_entry_dates
671: IS
672: SELECT effective_start_date,
673: effective_end_date
674: FROM PAY_ELEMENT_ENTRIES_F
675: WHERE element_entry_id = g_curr_element_entry_id;
676:
677: BEGIN
678: debug_enter(l_proc);

Line 987: p_element_entry_id pay_element_entries_f.element_entry_id%TYPE

983: l_return NUMBER;
984:
985: CURSOR csr_curr_element_input_values
986: (
987: p_element_entry_id pay_element_entries_f.element_entry_id%TYPE
988: ,p_effective_date DATE
989: )
990: IS
991: SELECT piv.NAME

Line 1008: FROM pay_element_entries_f peef

1004: )
1005: IS
1006: SELECT peef.element_type_id
1007: ,pet.element_name
1008: FROM pay_element_entries_f peef
1009: ,pay_element_types_f pet
1010: WHERE peef.element_entry_id = p_element_entry_id
1011: AND pet.element_type_id = peef.element_type_id;
1012:

Line 1034: IF l_chg_table <> 'PAY_ELEMENT_ENTRIES_F'

1030: debug('l_chg_type: '||l_chg_type,10);
1031: debug('l_chg_surrogate_key: '||l_chg_surrogate_key,10);
1032: debug('l_chg_date: '||l_chg_date,10);
1033:
1034: IF l_chg_table <> 'PAY_ELEMENT_ENTRIES_F'
1035: AND (l_chg_type NOT IN ('I','C') ) THEN
1036:
1037: debug('Not a valid event, will not be processed',20);
1038: debug_exit(l_proc);