APPS.PQH_GSP_RATES dependencies on PQH_GSP_UTILITY

Line 340: l_sot date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

336: ,p_copy_entity_txn_id in number ) is
337: gs_cnt number := 1;
338: l_esd date;
339: l_eed date;
340: l_sot date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
341: l_eot date := hr_general.end_of_time;
342: l_num_rec number;
343: begin
344: l_num_rec := p_dt_matx.count;

Line 420: l_rate_st_dt date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

416: and result_type_cd ='DISPLAY' -- which are displayed
417: and table_alias = 'HRRATE' -- check oipl row
418: and information278 = p_point_cer_id -- check rate of point row
419: order by 1 ;
420: l_rate_st_dt date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
421: l_abr_cer_id number;
422: l_hrr_cer_id number;
423: l_num_pt_rates number;
424: l_min_st_dt date;

Line 488: l_rate_st_dt date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

484: and table_alias = 'CRRATE' -- check oipl row
485: and information169 = p_point_cer_id -- check rate of point row
486: and information160 = p_crset_id
487: order by 1 ;
488: l_rate_st_dt date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
489: l_abr_cer_id number;
490: l_hrr_cer_id number;
491: l_crr_cer_id number;
492: l_num_pt_rates number;

Line 1123: l_start_date date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

1119: p_point_cer_id in number,
1120: p_point_value in number,
1121: p_datetrack_mode in varchar2) is
1122: l_abr_cer_id number;
1123: l_start_date date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
1124: l_dml_operation varchar2(30);
1125: l_datetrack_mode varchar2(30);
1126: l_old_hrrate_cer_id number;
1127: l_new_hrrate_cer_id number;