APPS.HRDPP_CREATE_US_PERSON_ADDRESS dependencies on HR_PUMP_GET

Line 284: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),vn)) p4,

280: l.pval002 d2,
281: decode(l.pval003,cn,vn,vn,null,l.pval003) p3,
282: l.pval003 d3,
283: decode(l.pval004,cn,vn,
284: hr_pump_get.gl(l.pval004,'YES_NO',d(l.pval001),vn)) p4,
285: decode(l.pval005,cn,dn,d(l.pval005)) p5,
286: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
287: l.pval006 d6,
288: decode(l.pval007,cn,vn,vn,vn,

Line 289: hr_pump_get.gl(l.pval007,'ADDRESS_TYPE',d(l.pval001),vn)) p7,

285: decode(l.pval005,cn,dn,d(l.pval005)) p5,
286: decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
287: l.pval006 d6,
288: decode(l.pval007,cn,vn,vn,vn,
289: hr_pump_get.gl(l.pval007,'ADDRESS_TYPE',d(l.pval001),vn)) p7,
290: l.pval007 d7,
291: l.plongval plongval,
292: decode(l.pval009,cn,vn,l.pval009) p9,
293: decode(l.pval010,cn,vn,vn,vn,l.pval010) p10,

Line 300: hr_pump_get.gl(l.pval013,'US_STATE',d(l.pval001),vn)) p13,

296: l.pval011 d11,
297: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
298: l.pval012 d12,
299: decode(l.pval013,cn,vn,vn,vn,
300: hr_pump_get.gl(l.pval013,'US_STATE',d(l.pval001),vn)) p13,
301: l.pval013 d13,
302: decode(l.pval014,cn,vn,vn,vn,l.pval014) p14,
303: l.pval014 d14,
304: decode(l.pval015,cn,vn,vn,vn,l.pval015) p15,

Line 434: hr_pump_get.get_person_id

430: if c.p50 is null then
431: L_PERSON_ID:=nn;
432: else
433: L_PERSON_ID :=
434: hr_pump_get.get_person_id
435: (P_PERSON_USER_KEY => c.p50);
436: end if;
437: --
438: if c.p51 is null then

Line 442: hr_pump_get.GET_COUNTRY

438: if c.p51 is null then
439: L_COUNTRY:=vn;
440: else
441: L_COUNTRY :=
442: hr_pump_get.GET_COUNTRY
443: (P_COUNTRY => c.p51);
444: end if;
445: --
446: hr_data_pump.api_trc_on;