DBA Data[Home] [Help]

APPS.HRI_PARAMETERS dependencies on PER_BUDGETS

Line 930: from per_budgets b ,per_budget_versions bv

926: ) IS
927:
928: cursor c_bgt_id is
929: select b.budget_id, b.name
930: from per_budgets b ,per_budget_versions bv
931: where b.business_group_id = g_bus_id
932: and b.budget_id = bv.budget_id
933: and trunc(sysdate) between bv.date_from and nvl( bv.date_to, sysdate+1 )
934: order by b.name ;

Line 1104: from per_budgets b ,per_budget_versions bv

1100: -- Parameter Request String : BGT_ID
1101:
1102: cursor c_bgt_id is
1103: select b.budget_id, b.name
1104: from per_budgets b ,per_budget_versions bv
1105: where b.business_group_id = g_bus_id
1106: and b.budget_id = bv.budget_id
1107: and trunc(sysdate) between bv.date_from and nvl( bv.date_to, sysdate+1 );
1108: