DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1430: FROM pay_element_entries_f pee

1426:
1427: CURSOR c_get_end_date
1428: IS
1429: SELECT MAX(pee.effective_end_date) effective_end_date
1430: FROM pay_element_entries_f pee
1431: WHERE pee.element_entry_id=p_element_entry_id
1432: AND pee.assignment_id=p_assignment_id;
1433:
1434: l_get_table_name c_get_table_name%ROWTYPE;

Line 1626: FROM pay_element_entries_f pee

1622: CURSOR c_get_end_date(cp_element_entry_id NUMBER
1623: ,cp_assignment_id NUMBER)
1624: IS
1625: SELECT MAX(pee.effective_end_date) effective_end_date
1626: FROM pay_element_entries_f pee
1627: WHERE pee.element_entry_id=cp_element_entry_id
1628: AND pee.assignment_id =cp_assignment_id;
1629:
1630: CURSOR c_get_process_status (cp_assignment_id NUMBER

Line 2339: FROM pay_element_entries_f pee

2335: SELECT pee.assignment_id
2336: ,pev1.screen_entry_value scr1
2337: ,pev2.screen_entry_value scr2
2338: ,pev1.element_entry_id
2339: FROM pay_element_entries_f pee
2340: ,pay_element_entry_values_f pev1
2341: ,pay_element_entry_values_f pev2
2342: WHERE pee.assignment_id=cp_assignment_id
2343: AND pee.element_entry_id=pev1.element_entry_id