APPS.PAY_RFM_BUS dependencies on PAY_REPORT_FORMAT_ITEMS_F

Line 410: from pay_report_format_items_f rfi

406: ) IS
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

Line 421: from pay_report_format_items_f rfi

417: and rfi.effective_end_date >= p_validation_start_date ;
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

Line 455: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');

451:
452: close csr_dt_rfi_exists;
453:
454: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
455: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');
456: fnd_message.raise_error;
457:
458: end if;
459: close csr_dt_rfi_exists;

Line 472: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');

468:
469: close csr_rfi_exists;
470:
471: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
472: fnd_message.set_token('TABLE_NAME', 'PAY_REPORT_FORMAT_ITEMS_F');
473: fnd_message.raise_error;
474:
475: end if;
476: close csr_rfi_exists;