APPS.PAY_KR_YEA_PKG dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 496: -- PAY_REPORT_FORMAT_ITEMS_F Cache

492: ) ;
493: --
494: g_user_entity_id t_user_entity_id;
495: ------------------------------------------------------------------------
496: -- PAY_REPORT_FORMAT_ITEMS_F Cache
497: ------------------------------------------------------------------------
498: type t_archive_item is record(
499: report_type pay_report_format_mappings_f.report_type%TYPE,
500: report_qualifier pay_report_format_mappings_f.report_qualifier%TYPE,

Line 1089: -- Refresh PAY_REPORT_FORMAT_ITEMS_F cache information

1085: and p_effective_date = g_archive_item.effective_date then
1086: null;
1087: else
1088: ------------------------------------------------------------------------
1089: -- Refresh PAY_REPORT_FORMAT_ITEMS_F cache information
1090: ------------------------------------------------------------------------
1091: select user_entity_id
1092: bulk collect into
1093: l_user_entity_id_tbl

Line 1094: from pay_report_format_items_f

1090: ------------------------------------------------------------------------
1091: select user_entity_id
1092: bulk collect into
1093: l_user_entity_id_tbl
1094: from pay_report_format_items_f
1095: where report_type = p_report_type
1096: and report_qualifier = p_report_qualifier
1097: and report_category = p_report_category
1098: and p_effective_date

Line 5380: from pay_report_format_items_f i,

5376: cursor csr_archive is
5377: select
5378: u.user_entity_id,
5379: a.value
5380: from pay_report_format_items_f i,
5381: ff_database_items d,
5382: ff_user_entities u,
5383: ff_archive_items a,
5384: pay_payroll_actions ppa,

Line 6357: pay_report_format_items_f i

6353: bulk collect into
6354: l_user_entity_id_tbl,
6355: l_user_entity_name_tbl
6356: from ff_user_entities u,
6357: pay_report_format_items_f i
6358: where i.report_type = 'YEA'
6359: and i.report_qualifier = 'KR'
6360: and u.user_entity_id = i.user_entity_id;
6361: --