APPS.PAY_KR_YEA_PKG dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 216: -- PAY_REPORT_FORMAT_ITEMS_F Cache

212: ) ;
213: --
214: g_user_entity_id t_user_entity_id;
215: ------------------------------------------------------------------------
216: -- PAY_REPORT_FORMAT_ITEMS_F Cache
217: ------------------------------------------------------------------------
218: type t_archive_item is record(
219: report_type pay_report_format_mappings_f.report_type%TYPE,
220: report_qualifier pay_report_format_mappings_f.report_qualifier%TYPE,

Line 530: -- Refresh PAY_REPORT_FORMAT_ITEMS_F cache information

526: and p_effective_date = g_archive_item.effective_date then
527: null;
528: else
529: ------------------------------------------------------------------------
530: -- Refresh PAY_REPORT_FORMAT_ITEMS_F cache information
531: ------------------------------------------------------------------------
532: select user_entity_id
533: bulk collect into
534: l_user_entity_id_tbl

Line 535: from pay_report_format_items_f

531: ------------------------------------------------------------------------
532: select user_entity_id
533: bulk collect into
534: l_user_entity_id_tbl
535: from pay_report_format_items_f
536: where report_type = p_report_type
537: and report_qualifier = p_report_qualifier
538: and report_category = p_report_category
539: and p_effective_date

Line 2123: from pay_report_format_items_f i,

2119: cursor csr_archive is
2120: select
2121: u.user_entity_id,
2122: a.value
2123: from pay_report_format_items_f i,
2124: ff_database_items d,
2125: ff_user_entities u,
2126: ff_archive_items a,
2127: pay_payroll_actions ppa,

Line 2905: pay_report_format_items_f i

2901: bulk collect into
2902: l_user_entity_id_tbl,
2903: l_user_entity_name_tbl
2904: from ff_user_entities u,
2905: pay_report_format_items_f i
2906: where i.report_type = 'YEA'
2907: and i.report_qualifier = 'KR'
2908: and u.user_entity_id = i.user_entity_id;
2909: --