APPS.PAY_MIX_ROLLBACK_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 70: from pay_element_types_f pet,

66: l_retcode number;
67:
68: cursor csr_check_classification is
69: select 'Y'
70: from pay_element_types_f pet,
71: pay_element_classifications pec
72: where pet.element_type_id = l_batch_line.element_type_id
73: and pet.CLASSIFICATION_ID = pec.CLASSIFICATION_ID
74: and pet.PROCESSING_TYPE = 'R'

Line 110: pay_element_types_f pet

106: select pee.element_entry_id, pee.creator_type,
107: pee.creator_id, pee.effective_start_date
108: from pay_element_entries_f pee,
109: pay_element_links_f pel,
110: pay_element_types_f pet
111: where pee.creator_id = p_batch_header_id
112: and pee.creator_type = 'H'
113: and (pee.source_id is null or pee.source_id = p_asg_action_id)
114: and pee.element_link_id = pel.element_link_id

Line 134: pay_element_types_f pet

130: pee.creator_id, pee.effective_start_date
131: from per_absence_attendances paa,
132: pay_element_entries_f pee,
133: pay_element_links_f pel,
134: pay_element_types_f pet
135: where paa.batch_id = p_batch_header_id
136: and pee.creator_id = paa.absence_attendance_id
137: and pee.creator_type = 'A'
138: and (pee.source_id is null or pee.source_id = p_asg_action_id)

Line 153: pay_element_types_f pet

149: select pee.element_entry_id, pee.creator_type,
150: pee.creator_id, pee.effective_start_date
151: from pay_element_entries_f pee,
152: pay_element_links_f pel,
153: pay_element_types_f pet
154: where pee.creator_id = p_batch_header_id
155: and pee.creator_type = 'H'
156: and (pee.source_id is null or pee.source_id = p_asg_action_id)
157: and pee.element_link_id = pel.element_link_id