DBA Data[Home] [Help]

APPS.PATC dependencies on PA_EXPENDITURE_ITEMS_ALL

Line 1830: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,

1826:
1827: /* Added procedure check_termination for Bug#4604614 (BaseBug#4118885) */
1828:
1829: procedure check_termination (p_person_id in per_all_people_f.person_id%type,
1830: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
1831: x_actual_termination_date out nocopy per_periods_of_service.actual_termination_date%type) IS
1832:
1833: cursor check_periods_of_service is
1834: select null

Line 1873: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,

1869: -- Bug 6156072: Base Bug 6045051: start
1870: -- Bug 6156072: Base Bug 6045051: new procedure added to check if EI Date falls between active service periods
1871: -- of the contingent worker. This is similar to procedure check_termination
1872: procedure check_termination_for_cwk (p_person_id in per_all_people_f.person_id%type,
1873: p_ei_date in pa_expenditure_items_all.expenditure_item_date%type,
1874: x_actual_termination_date out nocopy per_periods_of_placement.actual_termination_date%type) IS
1875:
1876: cursor check_periods_of_service is
1877: select null