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 470: cursor cc is SELECT element_name from pay_element_types_f

466: and nvl(effective_end_date,trunc(sysdate))
467: and payroll_id = p_val;
468:
469:
470: cursor cc is SELECT element_name from pay_element_types_f
471: WHERE nvl(business_group_id,nvl(p_business_group_id,-1))
472: = nvl(p_business_group_id,-1)
473: and element_type_id = p_val;
474:

Line 1233: cursor cc is SELECT element_type_id from pay_element_types_f

1229: and nvl(effective_end_date,trunc(sysdate))
1230: and payroll_name = p_meaning;
1231:
1232:
1233: cursor cc is SELECT element_type_id from pay_element_types_f
1234: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1235: = nvl(p_business_group_id,-1)
1236: and element_name = p_meaning;
1237:

Line 1243: and element_type_id = (SELECT element_type_id from pay_element_types_f

1239: cursor cd is SELECT input_value_id from pay_input_values_f
1240: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1241: = nvl(p_business_group_id,-1)
1242: and name = p_meaning
1243: and element_type_id = (SELECT element_type_id from pay_element_types_f
1244: WHERE nvl(business_group_id ,nvl(p_business_group_id,-1))
1245: = nvl(p_business_group_id,-1)
1246: and element_name = p_parent_meaning);
1247: