APPS.PQH_GSP_STAGE_TO_BEN dependencies on PQH_GSP_UTILITY

Line 1084: l_effective_date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

1080: l_ovn := r_OPT.information265;
1081: hr_utility.set_location(' l_opt_id '||l_opt_id,2);
1082: hr_utility.set_location(' point id '||r_opt.information257,3);
1083: if r_opt.dml_operation in ('INSERT','COPIED','UPD_INS') then
1084: l_effective_date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
1085: else
1086: l_effective_date := r_OPT.information2;
1087: end if;
1088: l_opt_name := build_opt_name(p_opt_cer_id => r_opt.copy_entity_result_id);

Line 1246: l_effective_date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);

1242: l_pl_id := r_pln.information1;
1243: l_ovn := r_pln.information265;
1244: hr_utility.set_location('for pln_id:'||l_pl_id ||'dml '||r_pln.dml_operation,2);
1245: if r_pln.dml_operation in ('INSERT','COPIED','UPD_INS') then
1246: l_effective_date := pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id,p_copy_entity_txn_id);
1247: else
1248: l_effective_date := r_pln.information2;
1249: end if;
1250: hr_utility.set_location('effdt is :'||to_char(l_effective_date,'DD/MM/RRRR'),3);

Line 3778: AND effective_start_date = pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id, null);

3774: FROM ben_ler_f
3775: WHERE typ_cd = 'GSP'
3776: AND lf_evt_oper_cd = 'SYNC'
3777: AND business_group_id = p_business_group_id
3778: AND effective_start_date = pqh_gsp_utility.get_gsp_plntyp_str_date(p_business_group_id, null);
3779:
3780: CURSOR csr_pgm_details (eff_date IN DATE)
3781: IS
3782: SELECT pgm_id