DBA Data[Home] [Help]

APPS.PQP_GB_MILEAGE_CLAIM_PKG dependencies on PAY_ELEMENT_ENTRIES_F

Line 1432: FROM pay_element_entries_f pee

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

Line 1638: FROM pay_element_entries_f pee

1634: CURSOR c_get_end_date(cp_element_entry_id NUMBER
1635: ,cp_assignment_id NUMBER)
1636: IS
1637: SELECT MAX(pee.effective_end_date) effective_end_date
1638: FROM pay_element_entries_f pee
1639: WHERE pee.element_entry_id=cp_element_entry_id
1640: AND pee.assignment_id =cp_assignment_id;
1641:
1642: CURSOR c_get_process_status (cp_assignment_id NUMBER

Line 2353: FROM pay_element_entries_f pee

2349: SELECT pee.assignment_id
2350: ,pev1.screen_entry_value scr1
2351: ,pev2.screen_entry_value scr2
2352: ,pev1.element_entry_id
2353: FROM pay_element_entries_f pee
2354: ,pay_element_entry_values_f pev1
2355: ,pay_element_entry_values_f pev2
2356: WHERE pee.assignment_id=cp_assignment_id
2357: AND pee.element_entry_id=pev1.element_entry_id