APPS.HRDPP_CREATE_CBR_QUALD_BNF dependencies on HR_PUMP_GET

Line 240: hr_pump_get.gl(l.pval002,'YES_NO',d(l.pval038),vn)) p2,

236: cursor cr is
237: select l.rowid myrowid,
238: l.pval001 p1,
239: decode(l.pval002,cn,vn,vn,vn,
240: hr_pump_get.gl(l.pval002,'YES_NO',d(l.pval038),vn)) p2,
241: l.pval002 d2,
242: decode(l.pval003,cn,dn,vn,dn,d(l.pval003)) p3,
243: l.pval003 d3,
244: decode(l.pval004,cn,dn,vn,dn,d(l.pval004)) p4,

Line 247: hr_pump_get.gl(l.pval005,'BEN_CBR_INELG_RSN',d(l.pval038),vn)) p5,

243: l.pval003 d3,
244: decode(l.pval004,cn,dn,vn,dn,d(l.pval004)) p4,
245: l.pval004 d4,
246: decode(l.pval005,cn,vn,vn,vn,
247: hr_pump_get.gl(l.pval005,'BEN_CBR_INELG_RSN',d(l.pval038),vn)) p5,
248: l.pval005 d5,
249: decode(l.pval006,cn,vn,vn,vn,l.pval006) p6,
250: l.pval006 d6,
251: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,

Line 351: hr_pump_get.get_quald_bnf_person_id

347: if c.p39 is null then
348: L_QUALD_BNF_PERSON_ID:=nn;
349: else
350: L_QUALD_BNF_PERSON_ID :=
351: hr_pump_get.get_quald_bnf_person_id
352: (P_QUALD_BNF_PERSON_USER_KEY => c.p39);
353: end if;
354: --
355: if c.p40 is null or

Line 360: hr_pump_get.get_pgm_id

356: c.p38 is null then
357: L_PGM_ID:=nn;
358: else
359: L_PGM_ID :=
360: hr_pump_get.get_pgm_id
361: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
362: ,P_PROGRAM => c.p40
363: ,P_EFFECTIVE_DATE => c.p38);
364: end if;

Line 370: hr_pump_get.get_ptip_id

366: if c.p41 is null then
367: L_PTIP_ID:=nn;
368: else
369: L_PTIP_ID :=
370: hr_pump_get.get_ptip_id
371: (P_PTIP_USER_KEY => c.p41);
372: end if;
373: --
374: if c.p42 is null or

Line 379: hr_pump_get.get_pl_typ_id

375: c.p38 is null then
376: L_PL_TYP_ID:=nn;
377: else
378: L_PL_TYP_ID :=
379: hr_pump_get.get_pl_typ_id
380: (P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
381: ,P_PLAN_TYPE => c.p42
382: ,P_EFFECTIVE_DATE => c.p38);
383: end if;

Line 389: hr_pump_get.get_cvrd_emp_person_id

385: if c.p43 is null then
386: L_CVRD_EMP_PERSON_ID:=nn;
387: else
388: L_CVRD_EMP_PERSON_ID :=
389: hr_pump_get.get_cvrd_emp_person_id
390: (P_CVRD_EMP_PERSON_USER_KEY => c.p43);
391: end if;
392: --
393: hr_data_pump.api_trc_on;