DBA Data[Home] [Help]

APPS.PAY_CN_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 131: FROM pay_element_types_f pet,

127: AND pai.action_information7 IS NULL;
128:
129: CURSOR csr_elem_name IS
130: SELECT petl.element_name
131: FROM pay_element_types_f pet,
132: pay_element_types_f_tl petl
133: WHERE pet.element_name = p_element_name
134: AND pet.legislation_code = 'CN'
135: AND pet.element_type_id = petl.element_type_id

Line 132: pay_element_types_f_tl petl

128:
129: CURSOR csr_elem_name IS
130: SELECT petl.element_name
131: FROM pay_element_types_f pet,
132: pay_element_types_f_tl petl
133: WHERE pet.element_name = p_element_name
134: AND pet.legislation_code = 'CN'
135: AND pet.element_type_id = petl.element_type_id
136: AND petl.language = userenv('LANG');

Line 213: FROM pay_element_types_f pet,

209: AND pai.action_information7 = p_input_value_name;
210:
211: CURSOR csr_elem_name IS
212: SELECT petl.element_name
213: FROM pay_element_types_f pet,
214: pay_element_types_f_tl petl
215: WHERE pet.element_name = p_element_name
216: AND pet.legislation_code = 'CN'
217: AND pet.element_type_id = petl.element_type_id

Line 214: pay_element_types_f_tl petl

210:
211: CURSOR csr_elem_name IS
212: SELECT petl.element_name
213: FROM pay_element_types_f pet,
214: pay_element_types_f_tl petl
215: WHERE pet.element_name = p_element_name
216: AND pet.legislation_code = 'CN'
217: AND pet.element_type_id = petl.element_type_id
218: AND petl.language = userenv('LANG');