APPS.PAY_RFI_SHD dependencies on PAY_REPORT_FORMAT_MAPPINGS_F

Line 186: ,pay_report_format_mappings_f m

182: Cursor C_Sel1 Is
183: select
184: m.report_format_mapping_id
185: from pay_report_format_items_f t
186: ,pay_report_format_mappings_f m
187: where t.report_format_item_id = p_base_key_value
188: and p_effective_date
189: between t.effective_start_date and t.effective_end_date
190: and t.report_type = m.report_type

Line 217: ,p_parent_table_name1 => 'pay_report_format_mappings_f'

213: (p_effective_date => p_effective_date
214: ,p_base_table_name => 'pay_report_format_items_f'
215: ,p_base_key_column => 'report_format_item_id'
216: ,p_base_key_value => p_base_key_value
217: ,p_parent_table_name1 => 'pay_report_format_mappings_f'
218: ,p_parent_key_column1 => 'report_format_mapping_id'
219: ,p_parent_key_value1 => l_parent_key_value1
220: ,p_zap => p_zap
221: ,p_delete => p_delete

Line 389: ,p_parent_table_name1 => 'pay_report_format_mappings_f'

385: ,p_datetrack_mode => p_datetrack_mode
386: ,p_base_table_name => 'pay_report_format_items_f'
387: ,p_base_key_column => 'report_format_item_id'
388: ,p_base_key_value => p_report_format_item_id
389: ,p_parent_table_name1 => 'pay_report_format_mappings_f'
390: ,p_parent_key_column1 => 'report_format_mapping_id'
391: ,p_parent_key_value1 => pay_rfi_shd.g_old_rec.report_format_mapping_id
392: ,p_enforce_foreign_locking => true
393: ,p_validation_start_date => l_validation_start_date