DBA Data[Home] [Help]

APPS.HRI_OPL_BDGTS dependencies on PER_TIME_PERIODS

Line 194: per_time_periods ptps,

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
198: AND prd.start_time_period_id = ptps.time_period_id

Line 195: per_time_periods ptpe

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
198: AND prd.start_time_period_id = ptps.time_period_id
199: AND prd.end_time_period_id = ptpe.time_period_id ;

Line 321: per_time_periods ptps,

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,
325: pqh_budget_fund_srcs src

Line 322: per_time_periods ptpe,

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,
325: pqh_budget_fund_srcs src
326: WHERE det.budget_version_id = p_budget_version_id