APPS.PAY_KR_REPORT_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1029: pay_element_types_f pet,

1025: is
1026: select pet.element_type_id,
1027: piv.input_value_id
1028: from pay_input_values_f piv,
1029: pay_element_types_f pet,
1030: pay_payroll_actions ppa,
1031: pay_assignment_actions paa
1032: where paa.assignment_action_id = p_assignment_action_id
1033: and ppa.payroll_action_id = paa.payroll_action_id

Line 1131: pay_element_types_f pet,

1127: is
1128: select pet.element_type_id,
1129: piv.input_value_id
1130: from pay_input_values_f piv,
1131: pay_element_types_f pet,
1132: pay_payroll_actions ppa,
1133: pay_assignment_actions paa
1134: where paa.assignment_action_id = p_assignment_action_id
1135: and ppa.payroll_action_id = paa.payroll_action_id

Line 1190: pay_element_types_f petf,

1186:
1187: select peevf.screen_entry_value from
1188: pay_element_entry_values_f peevf,
1189: pay_element_entries_f peef,
1190: pay_element_types_f petf,
1191: pay_input_values_f pivf
1192: WHERE peevf.element_entry_id = peef.element_entry_id
1193: and peef.element_type_id = petf.element_type_id
1194: and petf.element_name LIKE 'PREV_ER_INFO2'

Line 1208: pay_element_types_f petf,

1204: and peevf.element_entry_id = (
1205: SELECT peevf.element_entry_id element_entry_id
1206: FROM pay_element_entry_values_f peevf,
1207: pay_element_entries_f peef,
1208: pay_element_types_f petf,
1209: pay_input_values_f pivf
1210: WHERE peevf.element_entry_id = peef.element_entry_id
1211: and peef.element_type_id = petf.element_type_id
1212: and petf.element_name LIKE 'PREV_ER_INFO2'

Line 1305: pay_element_types_f pet,

1301: is
1302: select pet.element_type_id,
1303: piv.input_value_id
1304: from pay_input_values_f piv,
1305: pay_element_types_f pet,
1306: pay_payroll_actions ppa,
1307: pay_assignment_actions paa
1308: where paa.assignment_action_id = p_assignment_action_id
1309: and ppa.payroll_action_id = paa.payroll_action_id