DBA Data[Home] [Help]

APPS.PATC dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 2324: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,

2320:
2321: /* Added procedure check_termination for Bug#4604614 (BaseBug#4118885) */
2322:
2323: procedure check_termination (p_person_id in per_all_people_f.person_id%type,
2324: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
2325: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type) IS
2326:
2327: cursor check_periods_of_service is
2328: select null

Line 2367: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,

2363: -- Bug 6156072: Base Bug 6045051: start
2364: -- Bug 6156072: Base Bug 6045051: new procedure added to check if EI Date falls between active service periods
2365: -- of the contingent worker. This is similar to procedure check_termination
2366: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,
2367: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
2368: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type) IS
2369:
2370: cursor check_periods_of_service is
2371: select null