APPS.HRI_OPL_BDGTS dependencies on PQH_BUDGET

Line 192: FROM pqh_budget_details det,

188: ,l_user_id
189: ,l_user_id
190: ,l_user_id
191: ,SYSDATE
192: FROM pqh_budget_details det,
193: pqh_budget_periods prd,
194: per_time_periods ptps,
195: per_time_periods ptpe
196: WHERE det.budget_version_id = p_budget_version_id

Line 193: pqh_budget_periods prd,

189: ,l_user_id
190: ,l_user_id
191: ,SYSDATE
192: FROM pqh_budget_details det,
193: pqh_budget_periods prd,
194: per_time_periods ptps,
195: per_time_periods ptpe
196: WHERE det.budget_version_id = p_budget_version_id
197: AND det.budget_detail_id = prd.budget_detail_id

Line 319: FROM pqh_budget_details det,

315: ,l_user_id
316: ,l_user_id
317: ,l_user_id
318: ,SYSDATE
319: FROM pqh_budget_details det,
320: pqh_budget_periods prd,
321: per_time_periods ptps,
322: per_time_periods ptpe,
323: pqh_budget_sets bset,

Line 320: pqh_budget_periods prd,

316: ,l_user_id
317: ,l_user_id
318: ,SYSDATE
319: FROM pqh_budget_details det,
320: pqh_budget_periods prd,
321: per_time_periods ptps,
322: per_time_periods ptpe,
323: pqh_budget_sets bset,
324: pqh_budget_elements ele,

Line 323: pqh_budget_sets bset,

319: FROM pqh_budget_details det,
320: pqh_budget_periods prd,
321: per_time_periods ptps,
322: per_time_periods ptpe,
323: pqh_budget_sets bset,
324: pqh_budget_elements ele,
325: pqh_budget_fund_srcs src
326: WHERE det.budget_version_id = p_budget_version_id
327: AND det.budget_detail_id = prd.budget_detail_id

Line 324: pqh_budget_elements ele,

320: pqh_budget_periods prd,
321: per_time_periods ptps,
322: per_time_periods ptpe,
323: pqh_budget_sets bset,
324: pqh_budget_elements ele,
325: pqh_budget_fund_srcs src
326: WHERE det.budget_version_id = p_budget_version_id
327: AND det.budget_detail_id = prd.budget_detail_id
328: AND prd.budget_period_id = bset.budget_period_id

Line 325: pqh_budget_fund_srcs src

321: per_time_periods ptps,
322: per_time_periods ptpe,
323: pqh_budget_sets bset,
324: pqh_budget_elements ele,
325: pqh_budget_fund_srcs src
326: WHERE det.budget_version_id = p_budget_version_id
327: AND det.budget_detail_id = prd.budget_detail_id
328: AND prd.budget_period_id = bset.budget_period_id
329: AND prd.start_time_period_id = ptps.time_period_id

Line 387: NVL(bdgt.currency_code, pqh_budget.get_currency_cd(bdgt.budget_id)) CURRENCY_CODE,

383: SELECT bdgt.budget_id,
384: bdgt.budget_name,
385: bdgt.business_group_id,
386: bdgt.budgeted_entity_cd,
387: NVL(bdgt.currency_code, pqh_budget.get_currency_cd(bdgt.budget_id)) CURRENCY_CODE,
388: bdgt.budget_unit1_id,
389: bdgt.budget_unit2_id,
390: bdgt.budget_unit3_id,
391: bdgt.budget_unit1_aggregate,

Line 399: FROM pqh_budgets bdgt,

395: bdgt.budget_end_date,
396: ver.budget_version_id,
397: ver.date_from,
398: ver.date_to
399: FROM pqh_budgets bdgt,
400: pqh_budget_versions ver
401: WHERE bdgt.position_control_flag = 'Y'
402: AND bdgt.budgeted_entity_cd IN ('ORGANIZATION','POSITION')
403: AND bdgt.budget_id = ver.budget_id

Line 400: pqh_budget_versions ver

396: ver.budget_version_id,
397: ver.date_from,
398: ver.date_to
399: FROM pqh_budgets bdgt,
400: pqh_budget_versions ver
401: WHERE bdgt.position_control_flag = 'Y'
402: AND bdgt.budgeted_entity_cd IN ('ORGANIZATION','POSITION')
403: AND bdgt.budget_id = ver.budget_id
404: AND (( bdgt.budget_start_date BETWEEN g_refresh_start_date AND g_refresh_end_date )

Line 407: FROM pqh_budget_versions pbv

403: AND bdgt.budget_id = ver.budget_id
404: AND (( bdgt.budget_start_date BETWEEN g_refresh_start_date AND g_refresh_end_date )
405: OR ( g_refresh_start_date BETWEEN bdgt.budget_start_date AND bdgt.budget_end_date ))
406: AND ver.budget_version_id = ( SELECT max(budget_version_id)
407: FROM pqh_budget_versions pbv
408: WHERE pbv.budget_id = bdgt.budget_id );
409: BEGIN
410: --
411: dbg('Inside process');