DBA Data[Home] [Help]

APPS.PAY_US_BEE dependencies on PAY_ELEMENT_TYPES_F

Line 64: from pay_element_types_f elt

60: -- have to use element_type_id to get element_name
61:
62: select elt.element_name
63: into l_element_name
64: from pay_element_types_f elt
65: where elt.element_type_id = g_line_record.element_type_id
66: and (elt.business_group_id +0 = g_header_record.business_group_id
67: or (elt.business_group_id is null
68: and elt.legislation_code = 'US'))

Line 94: from pay_element_types_f pet

90: begin
91:
92: select element_type_id
93: into l_base_element_type_id
94: from pay_element_types_f pet
95: where pet.element_name = l_base_element_name
96: and pet.processing_type = 'R'
97: and (pet.business_group_id = g_header_record.business_group_id
98: or (pet.business_group_id IS NULL