APPS.PAY_KR_SEP_FORM_PKG dependencies on PAY_ELEMENT_LINKS_F

Line 336: pay_element_links_f pel,

332: cursor C_Sel1 is
333: select pee.entry_type,
334: pet.processing_type
335: from pay_element_types_f pet,
336: pay_element_links_f pel,
337: pay_element_entries_f pee
338: where pee.element_entry_id = p_base_key_value
339: and p_effective_date
340: between pee.effective_start_date and pee.effective_end_date

Line 414: pay_element_links_f pel,

410: pee.element_link_id,
411: pee.entry_type,
412: pet.processing_type
413: from pay_element_types_f pet,
414: pay_element_links_f pel,
415: pay_element_entries_f pee
416: where pee.element_entry_id = p_base_key_value
417: and p_effective_date
418: between pee.effective_start_date and pee.effective_end_date

Line 463: p_parent_table_name2 => 'pay_element_links_f',

459: p_base_key_value => p_base_key_value,
460: p_parent_table_name1 => 'per_all_assignments_f',
461: p_parent_key_column1 => 'assignment_id',
462: p_parent_key_value1 => l_parent_key_value1,
463: p_parent_table_name2 => 'pay_element_links_f',
464: p_parent_key_column2 => 'element_link_id',
465: p_parent_key_value2 => l_parent_key_value2,
466: p_zap => p_zap,
467: p_delete => p_delete,

Line 607: p_parent_table_name2 => 'pay_element_links_f',

603: p_base_key_value => p_element_entry_id,
604: p_parent_table_name1 => 'per_all_assignments_f',
605: p_parent_key_column1 => 'assignment_id',
606: p_parent_key_value1 => g_old_rec.assignment_id,
607: p_parent_table_name2 => 'pay_element_links_f',
608: p_parent_key_column2 => 'element_link_id',
609: p_parent_key_value2 => g_old_rec.element_link_id,
610: p_enforce_foreign_locking => true,
611: p_validation_start_date => l_validation_start_date,

Line 2137: pay_element_links_f pel

2133: and petr.element_type_id not in(
2134: select distinct pet.element_type_id
2135: from pay_element_entries_f pee,
2136: pay_element_types_f pet,
2137: pay_element_links_f pel
2138: where assignment_id = p_assignment_id
2139: and pet.element_type_id = pel.element_type_id
2140: and pee.element_link_id = pel.element_link_id
2141: and p_session_date between pet.effective_start_date and pet.effective_end_date

Line 2221: pay_element_links_f pel

2217: and petr.element_type_id not in(
2218: select distinct pet.element_type_id
2219: from pay_element_entries_f pee,
2220: pay_element_types_f pet,
2221: pay_element_links_f pel
2222: where assignment_id = p_assignment_id
2223: and pet.element_type_id = pel.element_type_id
2224: and pee.element_link_id = pel.element_link_id
2225: and p_session_date between pet.effective_start_date and pet.effective_end_date