APPS.PAY_CA_YEER_PKG dependencies on FF_ARCHIVE_ITEMS

Line 2915: ,ff_archive_items fai

2911: initcap(rtrim(ltrim(replace(replace(replace(replace(replace(replace(
2912: fdi.user_name,'CAEOY'),'RL1_'),'PER_YTD'),'PER_JD_YTD'),'EMPLOYEE_'),
2913: '_',' ')))) req_col
2914: from ff_database_items fdi
2915: ,ff_archive_items fai
2916: where fai.user_entity_id = fdi.user_entity_id
2917: and fai.context1 = to_char(cp_context)
2918: and fdi.user_name like 'CAEOY%';
2919:

Line 3356: ,ff_archive_items fai

3352: replace(replace( fdi.user_name,'CAEOY'),'T4A'),'T4'),'PER_GRE_YTD')
3353: ,'PER_JD_GRE_YTD'),'EMPLOYEE_'),'_',' ')))) req_col,
3354: fai.archive_item_id
3355: from ff_database_items fdi
3356: ,ff_archive_items fai
3357: where fai.user_entity_id = fdi.user_entity_id
3358: and fai.context1 = to_char(cp_context)
3359: and fdi.user_name like 'CAEOY%';
3360:

Line 3365: ,ff_archive_items fai

3361: /* Cursor to find the Employment Jurisdiction code for the employee */
3362: cursor get_jurisdiction_code( cp_context in number ) is
3363: select rtrim(ltrim(fai.value))
3364: from ff_database_items fdi
3365: ,ff_archive_items fai
3366: where fai.user_entity_id = fdi.user_entity_id
3367: and fai.context1 = to_char(cp_context)
3368: and fdi.user_name = 'CAEOY_PROVINCE_OF_EMPLOYMENT';
3369: