APPS.PQH_BDGT_REALLOC_UTILITY dependencies on PQH_BUDGET_DETAILS

Line 145: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

141: --
142:
143: FUNCTION GET_DTL_REALLOC_RESERVED_AMT
144: (
145: p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
146: p_budget_unit_id IN pqh_budgets.budget_unit1_id%TYPE,
147: p_transaction_type IN pqh_bdgt_pool_realloctions.transaction_type%TYPE DEFAULT 'DD',
148: p_approval_status IN varchar2,
149: p_amount_type IN varchar2,

Line 528: p_organization_id IN pqh_budget_details.organization_id%TYPE,

524: --
525: FUNCTION GET_LOCATION_CODE
526: (
527: p_entity_code IN pqh_budgets.budgeted_entity_cd%TYPE,
528: p_organization_id IN pqh_budget_details.organization_id%TYPE,
529: p_business_group_id IN hr_organization_units_v.business_group_id%TYPE
530: ) RETURN VARCHAR
531: IS
532: l_location_code VARCHAR2(30);

Line 883: ( p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,

879: --
880: End apply_transaction;
881:
882: FUNCTION entity_id
883: ( p_budget_detail_id IN pqh_budget_details.budget_detail_id%TYPE,
884: p_entity_type IN pqh_budgets.budgeted_entity_cd%TYPE
885: )RETURN NUMBER
886: IS
887: l_entity_id NUMBER :=0;

Line 891: from pqh_budget_details

887: l_entity_id NUMBER :=0;
888: CURSOR csr_details
889: IS
890: select job_id,position_id,grade_id,organization_id
891: from pqh_budget_details
892: where budget_detail_id = p_budget_detail_id;
893: rec_details csr_details%ROWTYPE;
894: BEGIN
895: OPEN csr_details;