APPS.PAY_ELE_SHD dependencies on PAY_ELEMENT_LINKS_F

Line 237: pay_element_links_f pel

233: Cursor C_chk_type Is
234: select pet.processing_type
235: from pay_element_types_f pet,
236: pay_element_entries_f pee,
237: pay_element_links_f pel
238: where pet.element_type_id = pel.element_type_id
239: and pel.element_link_id = pee.element_link_id
240: and pee.element_entry_id = p_base_key_value
241: and p_effective_date

Line 320: pay_element_links_f pel

316: Cursor C_chk_type Is
317: select pet.processing_type
318: from pay_element_types_f pet,
319: pay_element_entries_f pee,
320: pay_element_links_f pel
321: where pet.element_type_id = pel.element_type_id
322: and pel.element_link_id = pee.element_link_id
323: and pee.element_entry_id = p_base_key_value
324: and p_effective_date

Line 356: ,p_parent_table_name2 => 'pay_element_links_f'

352: ,p_base_key_value => p_base_key_value
353: ,p_parent_table_name1 => 'per_all_assignments_f'
354: ,p_parent_key_column1 => 'assignment_id'
355: ,p_parent_key_value1 => l_parent_key_value1
356: ,p_parent_table_name2 => 'pay_element_links_f'
357: ,p_parent_key_column2 => 'element_link_id'
358: ,p_parent_key_value2 => l_parent_key_value2
359: ,p_zap => p_zap
360: ,p_delete => p_delete

Line 658: -- We must also lock the pay_element_links_f in shared mode.

654: for i in c_sel4 loop
655: null;
656: end loop;
657:
658: -- We must also lock the pay_element_links_f in shared mode.
659: lock table pay_element_links_f in row share mode nowait;
660:
661: --
662: -- Validate the datetrack mode mode getting the validation start

Line 659: lock table pay_element_links_f in row share mode nowait;

655: null;
656: end loop;
657:
658: -- We must also lock the pay_element_links_f in shared mode.
659: lock table pay_element_links_f in row share mode nowait;
660:
661: --
662: -- Validate the datetrack mode mode getting the validation start
663: -- and end dates for the specified datetrack operation.

Line 674: ,p_parent_table_name2 => 'pay_element_links_f'

670: ,p_base_key_value => p_element_entry_id
671: ,p_parent_table_name1 => 'per_all_assignments_f'
672: ,p_parent_key_column1 => 'assignment_id'
673: ,p_parent_key_value1 => pay_ele_shd.g_old_rec.assignment_id
674: ,p_parent_table_name2 => 'pay_element_links_f'
675: ,p_parent_key_column2 => 'element_link_id'
676: ,p_parent_key_value2 => pay_ele_shd.g_old_rec.element_link_id
677: ,p_enforce_foreign_locking => false
678: ,p_validation_start_date => l_validation_start_date