DBA Data[Home] [Help]

APPS.PAY_CA_BEE dependencies on PAY_ELEMENT_TYPES_F

Line 98: from pay_element_types_f elt

94: -- have to use element_type_id to get element_name
95:
96: select elt.element_name
97: into l_element_name
98: from pay_element_types_f elt
99: where elt.element_type_id = g_line_record.element_type_id
100: and (elt.business_group_id +0 = g_header_record.business_group_id
101: or (elt.business_group_id is null
102: and elt.legislation_code = 'CA'))

Line 128: from pay_element_types_f pet

124: begin
125:
126: select element_type_id
127: into l_base_element_type_id
128: from pay_element_types_f pet
129: where pet.element_name = l_base_element_name
130: and pet.processing_type = 'R'
131: and (pet.business_group_id = g_header_record.business_group_id
132: or (pet.business_group_id IS NULL