APPS.PAY_CA_YEER_PKG dependencies on FF_ARCHIVE_ITEMS

Line 3281: ,ff_archive_items fai

3277: initcap(rtrim(ltrim(replace(replace(replace(replace(replace(replace(replace(
3278: fdi.user_name,'CAEOY'),'RL1_'),'PER_YTD'),'PER_JD_YTD'),'AMOUNT'),'EMPLOYEE_'),
3279: '_',' ')))) req_col /* bug 4393047 - Added AMOUNT */
3280: from ff_database_items fdi
3281: ,ff_archive_items fai
3282: where fai.user_entity_id = fdi.user_entity_id
3283: and fai.context1 = to_char(cp_context)
3284: and fdi.user_name like 'CAEOY%'
3285: order by req_col; -- Bug 15908452

Line 3818: ,ff_archive_items fai

3814: replace(replace( fdi.user_name,'CAEOY'),'T4A'),'_T4'),'PER_GRE_YTD')
3815: ,'PER_JD_GRE_YTD'),'EMPLOYEE_'),'_',' ')))) req_col,
3816: fai.archive_item_id
3817: from ff_database_items fdi
3818: ,ff_archive_items fai
3819: where fai.user_entity_id = fdi.user_entity_id
3820: and fai.context1 = to_char(cp_context)
3821: and fdi.user_name like 'CAEOY%'
3822: order by req_col; -- order by added by rgottipa by 10085168

Line 3828: ,ff_archive_items fai

3824: /* Cursor to find the Employment Jurisdiction code for the employee */
3825: cursor get_jurisdiction_code( cp_context in number ) is
3826: select rtrim(ltrim(fai.value))
3827: from ff_database_items fdi
3828: ,ff_archive_items fai
3829: where fai.user_entity_id = fdi.user_entity_id
3830: and fai.context1 = to_char(cp_context)
3831: and fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';
3832: