APPS.PAY_RFM_BUS dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 25: , pay_report_format_mappings_f rfm

21: cursor csr_sec_grp is
22: select pbg.security_group_id,
23: pbg.legislation_code
24: from per_business_groups_perf pbg
25: , pay_report_format_mappings_f rfm
26: where rfm.report_format_mapping_id = p_report_format_mapping_id
27: and pbg.business_group_id (+) = rfm.business_group_id;
28: --
29: -- Declare local variables

Line 90: from pay_report_format_mappings_f

86: ( p_report_format_mapping_id in number ) IS
87: --
88: cursor csr_unique_id is
89: select null
90: from pay_report_format_mappings_f
91: where report_format_mapping_id = p_report_format_mapping_id;
92: --
93: l_proc varchar2(72) := g_package || 'chk_report_format_mapping_id';
94: l_exists varchar2(1);

Line 162: from pay_report_format_mappings_f

158: ) IS
159: --
160: cursor csr_unique_key is
161: select null
162: from pay_report_format_mappings_f
163: where report_type = p_report_type
164: and report_qualifier = p_report_qualifier
165: and report_category = p_report_category;
166: --

Line 411: ,pay_report_format_mappings_f rfm

407: --
408: cursor csr_dt_rfi_exists is
409: select null
410: from pay_report_format_items_f rfi
411: ,pay_report_format_mappings_f rfm
412: where rfm.report_format_mapping_id = p_report_format_mapping_id
413: and rfm.object_version_number = p_object_version_number
414: and rfm.report_type = rfi.report_type
415: and rfm.report_qualifier = rfi.report_qualifier

Line 422: ,pay_report_format_mappings_f rfm

418: --
419: cursor csr_rfi_exists is
420: select null
421: from pay_report_format_items_f rfi
422: ,pay_report_format_mappings_f rfm
423: where rfm.report_format_mapping_id = p_report_format_mapping_id
424: and rfm.object_version_number = p_object_version_number
425: and rfm.report_type = rfi.report_type
426: and rfm.report_qualifier = rfi.report_qualifier