eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXTRACT_SEED dependencies on PAY_ELEMENT_TYPES_F

Line 417: cursor cc is SELECT element_name from pay_element_types_f

413: and nvl(effective_end_date,trunc(sysdate))
414: and payroll_id = p_val;
415:
416:
417: cursor cc is SELECT element_name from pay_element_types_f
418: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
419: = nvl(p_business_group_id,-1)
420: and element_type_id = p_val;
421:

Line 1180: cursor cc is SELECT element_type_id from pay_element_types_f

1176: and nvl(effective_end_date,trunc(sysdate))
1177: and payroll_name = p_meaning;
1178:
1179:
1180: cursor cc is SELECT element_type_id from pay_element_types_f
1181: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1182: = nvl(p_business_group_id,-1)
1183: and element_name = p_meaning;
1184:

Line 1190: and element_type_id = (SELECT element_type_id from pay_element_types_f

1186: cursor cd is SELECT input_value_id from pay_input_values_f
1187: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1188: = nvl(p_business_group_id,-1)
1189: and name = p_meaning
1190: and element_type_id = (SELECT element_type_id from pay_element_types_f
1191: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1192: = nvl(p_business_group_id,-1)
1193: and element_name = p_parent_meaning);
1194: