APPS.PAY_CN_AUDIT_XMLGEN dependencies on PAY_ELEMENT_LINKS_F

Line 1353: from pay_element_links_f

1349:
1350: /* cursor to fetch the expense category code segment*/
1351: CURSOR c_exp_cat_code(p_element_id IN NUMBER) IS
1352: select COST_ALLOCATION_KEYFLEX_ID
1353: from pay_element_links_f
1354: where business_group_id = g_bg_id
1355: and element_type_id = p_element_id
1356: and effective_start_date =
1357: (select min(effective_start_date) from pay_element_links_f where business_group_id = g_bg_id

Line 1357: (select min(effective_start_date) from pay_element_links_f where business_group_id = g_bg_id

1353: from pay_element_links_f
1354: where business_group_id = g_bg_id
1355: and element_type_id = p_element_id
1356: and effective_start_date =
1357: (select min(effective_start_date) from pay_element_links_f where business_group_id = g_bg_id
1358: and element_type_id = p_element_id);
1359:
1360: l_cost_seg VARCHAR2(100);
1361: l_cost_id NUMBER;