DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 2356: from ff_archive_item_contexts

2352: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' OR
2353: sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2354:
2355: select context into sv_emp_jurisdiction
2356: from ff_archive_item_contexts
2357: where archive_item_id = sv_dbi(i).archive_item_id
2358: and context_id = sv_context_id;
2359:
2360: hr_utility.trace('Emp JD is '||sv_emp_jurisdiction);

Line 2418: from ff_archive_item_contexts

2414: (sv_report_type = 'CAEOY_T4_AMEND_PP')) then
2415: begin
2416: select context
2417: into sv_emp_jurisdiction
2418: from ff_archive_item_contexts
2419: where archive_item_id = sv_dbi(i).archive_item_id
2420: and context_id = sv_context_id;
2421:
2422: exception