DBA Data[Home] [Help]

APPS.PQH_COMMITMENT_PKG dependencies on PER_SHARED_TYPES

Line 3239: from per_shared_types

3235: v_curr_day VARCHAR2(3):= NULL; -- 3 char abbrev for day of wk.
3236:
3237: cursor csr_working_days is
3238: select information3
3239: from per_shared_types
3240: where lookup_type ='FREQUENCY'
3241: and system_type_cd = p_std_freq;
3242: BEGIN -- standard_hours_worked
3243: --

Line 3685: From PQH_BUDGETS bdgts,per_shared_types shtyps

3681: -- Control Budget (position - money) as of the effective date for the current BG
3682: Cursor csr_get_ctrl_bdgt IS
3683: Select bdgts.budget_id,budget_name,period_set_name ,
3684: budget_start_date,budget_end_date
3685: From PQH_BUDGETS bdgts,per_shared_types shtyps
3686: where p_effective_date between budget_start_date and budget_end_date
3687: and position_control_flag ='Y'
3688: and budgeted_entity_cd ='POSITION'
3689: and shtyps.shared_type_id = bdgts.budget_unit1_id