DBA Data[Home] [Help]

APPS.HRI_OPL_CMNTS dependencies on PQH_BUDGET_VERSIONS

Line 203: AND pbce.budget_id = (SELECT budget_id FROM pqh_budget_versions WHERE budget_version_id = pec.budget_version_id)

199: WHERE pec.assignment_id = paaf.assignment_id
200: AND pec.element_type_id = petf.element_type_id
201: AND paaf.pay_basis_id = ppb.pay_basis_id
202: AND pbce.element_type_id = pec.element_type_id
203: AND pbce.budget_id = (SELECT budget_id FROM pqh_budget_versions WHERE budget_version_id = pec.budget_version_id)
204: AND pbce.actual_commitment_type IN ('COMMITMENT','BOTH')
205: AND pec.commitment_start_date BETWEEN petf.effective_start_date AND petf.effective_end_date
206: AND pec.commitment_start_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
207: AND pec.assignment_id BETWEEN p_start_object_id AND p_end_object_id