DBA Data[Home] [Help]

APPS.PAY_CA_YEER_PKG dependencies on FF_ARCHIVE_ITEM_CONTEXTS

Line 2681: from ff_archive_item_contexts

2677: if sv_dbi(i).dbi_name = 'CAEOY_EI_EE_TAXABLE_PER_JD_GRE_YTD' OR
2678: sv_dbi(i).dbi_name = 'CAEOY_EI_EE_WITHHELD_PER_JD_GRE_YTD' then
2679:
2680: select context into sv_emp_jurisdiction
2681: from ff_archive_item_contexts
2682: where archive_item_id = sv_dbi(i).archive_item_id
2683: and context_id = sv_context_id;
2684:
2685: hr_utility.trace('Emp JD is '||sv_emp_jurisdiction);

Line 2743: from ff_archive_item_contexts

2739: (sv_report_type = 'CAEOY_T4_AMEND_PP')) then
2740: begin
2741: select context
2742: into sv_emp_jurisdiction
2743: from ff_archive_item_contexts
2744: where archive_item_id = sv_dbi(i).archive_item_id
2745: and context_id = sv_context_id;
2746:
2747: exception