APPS.HRI_OLTP_DISC_WRKFRC dependencies on PQH_BUDGETS

Line 437: /* cbridge, 28/06/2001 , pqh budgets support function for */

433: END get_asg_budget_value;
434:
435:
436: /******************************************************************************/
437: /* cbridge, 28/06/2001 , pqh budgets support function for */
438: /* hrfv_workforce_budgets business view */
439: /* Public function to calculate workforce actuals for a single assignment */
440: /* using new PQH budgets schema model */
441: /* bug enhancement 1317484 */

Line 440: /* using new PQH budgets schema model */

436: /******************************************************************************/
437: /* cbridge, 28/06/2001 , pqh budgets support function for */
438: /* hrfv_workforce_budgets business view */
439: /* Public function to calculate workforce actuals for a single assignment */
440: /* using new PQH budgets schema model */
441: /* bug enhancement 1317484 */
442: /******************************************************************************/
443: FUNCTION get_ff_actual_value_pqh
444: (p_budget_id IN NUMBER

Line 460: from pqh_budgets bgt

456: select pst1.system_type_cd unit1_name
457: , pst2.system_type_cd unit2_name
458: , pst3.system_type_cd unit3_name
459: , bgt.business_group_id business_group_id
460: from pqh_budgets bgt
461: , per_shared_types_vl pst1
462: , per_shared_types_vl pst2
463: , per_shared_types_vl pst3
464: where bgt.budget_id = p_budget_id

Line 944: FROM pqh_budgets bgt

940: SELECT pst1.system_type_cd unit1_name
941: , pst2.system_type_cd unit2_name
942: , pst3.system_type_cd unit3_name
943: , bgt.business_group_id business_group_id
944: FROM pqh_budgets bgt
945: , per_shared_types_vl pst1
946: , per_shared_types_vl pst2
947: , per_shared_types_vl pst3
948: WHERE bgt.budget_id = p_budget_id