APPS.HRDPP_CREATE_COMPETENCE dependencies on HR_PUMP_GET

Line 413: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval002)) p8,

409: l.pval006 d6,
410: decode(l.pval007,cn,vn,vn,vn,l.pval007) p7,
411: l.pval007 d7,
412: decode(l.pval008,cn,vn,vn,vn,
413: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval002)) p8,
414: l.pval008 d8,
415: decode(l.pval009,cn,vn,vn,vn,
416: hr_pump_get.gl(l.pval009,'COMPETENCE_EVAL_TYPE',d(l.pval001),l.pval002)) p9,
417: l.pval009 d9,

Line 416: hr_pump_get.gl(l.pval009,'COMPETENCE_EVAL_TYPE',d(l.pval001),l.pval002)) p9,

412: decode(l.pval008,cn,vn,vn,vn,
413: hr_pump_get.gl(l.pval008,'YES_NO',d(l.pval001),l.pval002)) p8,
414: l.pval008 d8,
415: decode(l.pval009,cn,vn,vn,vn,
416: hr_pump_get.gl(l.pval009,'COMPETENCE_EVAL_TYPE',d(l.pval001),l.pval002)) p9,
417: l.pval009 d9,
418: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
419: l.pval010 d10,
420: decode(l.pval011,cn,vn,vn,vn,

Line 421: hr_pump_get.gl(l.pval011,'FREQUENCY',d(l.pval001),l.pval002)) p11,

417: l.pval009 d9,
418: decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
419: l.pval010 d10,
420: decode(l.pval011,cn,vn,vn,vn,
421: hr_pump_get.gl(l.pval011,'FREQUENCY',d(l.pval001),l.pval002)) p11,
422: l.pval011 d11,
423: decode(l.pval012,cn,vn,vn,vn,l.pval012) p12,
424: l.pval012 d12,
425: decode(l.pval013,cn,vn,vn,vn,l.pval013) p13,

Line 536: hr_pump_get.gl(l.pval070,'PER_QUAL_FWK_CREDIT_TYPE',d(l.pval001),l.pval002)) p70,

532: l.pval068 d68,
533: decode(l.pval069,cn,vn,vn,vn,l.pval069) p69,
534: l.pval069 d69,
535: decode(l.pval070,cn,vn,vn,vn,
536: hr_pump_get.gl(l.pval070,'PER_QUAL_FWK_CREDIT_TYPE',d(l.pval001),l.pval002)) p70,
537: l.pval070 d70,
538: decode(l.pval071,cn,nn,vn,nn,n(l.pval071)) p71,
539: l.pval071 d71,
540: decode(l.pval072,cn,vn,vn,vn,

Line 541: hr_pump_get.gl(l.pval072,'PER_QUAL_FWK_LEVEL_TYPE',d(l.pval001),l.pval002)) p72,

537: l.pval070 d70,
538: decode(l.pval071,cn,nn,vn,nn,n(l.pval071)) p71,
539: l.pval071 d71,
540: decode(l.pval072,cn,vn,vn,vn,
541: hr_pump_get.gl(l.pval072,'PER_QUAL_FWK_LEVEL_TYPE',d(l.pval001),l.pval002)) p72,
542: l.pval072 d72,
543: decode(l.pval073,cn,nn,vn,nn,
544: hr_pump_get.gl(l.pval073,'PER_QUAL_FWK_LEVEL',d(l.pval001),l.pval002)) p73,
545: l.pval073 d73,

Line 544: hr_pump_get.gl(l.pval073,'PER_QUAL_FWK_LEVEL',d(l.pval001),l.pval002)) p73,

540: decode(l.pval072,cn,vn,vn,vn,
541: hr_pump_get.gl(l.pval072,'PER_QUAL_FWK_LEVEL_TYPE',d(l.pval001),l.pval002)) p72,
542: l.pval072 d72,
543: decode(l.pval073,cn,nn,vn,nn,
544: hr_pump_get.gl(l.pval073,'PER_QUAL_FWK_LEVEL',d(l.pval001),l.pval002)) p73,
545: l.pval073 d73,
546: decode(l.pval074,cn,vn,vn,vn,
547: hr_pump_get.gl(l.pval074,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p74,
548: l.pval074 d74,

Line 547: hr_pump_get.gl(l.pval074,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p74,

543: decode(l.pval073,cn,nn,vn,nn,
544: hr_pump_get.gl(l.pval073,'PER_QUAL_FWK_LEVEL',d(l.pval001),l.pval002)) p73,
545: l.pval073 d73,
546: decode(l.pval074,cn,vn,vn,vn,
547: hr_pump_get.gl(l.pval074,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p74,
548: l.pval074 d74,
549: decode(l.pval075,cn,vn,vn,vn,
550: hr_pump_get.gl(l.pval075,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p75,
551: l.pval075 d75,

Line 550: hr_pump_get.gl(l.pval075,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p75,

546: decode(l.pval074,cn,vn,vn,vn,
547: hr_pump_get.gl(l.pval074,'PER_QUAL_FWK_FIELD',d(l.pval001),l.pval002)) p74,
548: l.pval074 d74,
549: decode(l.pval075,cn,vn,vn,vn,
550: hr_pump_get.gl(l.pval075,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p75,
551: l.pval075 d75,
552: decode(l.pval076,cn,vn,vn,vn,
553: hr_pump_get.gl(l.pval076,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p76,
554: l.pval076 d76,

Line 553: hr_pump_get.gl(l.pval076,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p76,

549: decode(l.pval075,cn,vn,vn,vn,
550: hr_pump_get.gl(l.pval075,'PER_QUAL_FWK_SUB_FIELD',d(l.pval001),l.pval002)) p75,
551: l.pval075 d75,
552: decode(l.pval076,cn,vn,vn,vn,
553: hr_pump_get.gl(l.pval076,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p76,
554: l.pval076 d76,
555: decode(l.pval077,cn,vn,vn,vn,
556: hr_pump_get.gl(l.pval077,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p77,
557: l.pval077 d77,

Line 556: hr_pump_get.gl(l.pval077,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p77,

552: decode(l.pval076,cn,vn,vn,vn,
553: hr_pump_get.gl(l.pval076,'PER_QUAL_FWK_PROVIDER',d(l.pval001),l.pval002)) p76,
554: l.pval076 d76,
555: decode(l.pval077,cn,vn,vn,vn,
556: hr_pump_get.gl(l.pval077,'PER_QUAL_FWK_QA_ORG',d(l.pval001),l.pval002)) p77,
557: l.pval077 d77,
558: decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
559: l.pval078 d78,
560: decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,