DBA Data[Home] [Help]

APPS.HRDPP_UPDATE_SG_PERSONAL_PAY_M dependencies on HR_PUMP_GET

Line 239: hr_pump_get.gl(l.pval005,'SG_ACCOUNT_TYPE',d(l.pval001),l.pval043)) p5,

235: l.pval003 d3,
236: decode(l.pval004,cn,vn,vn,vh,l.pval004) p4,
237: l.pval004 d4,
238: decode(l.pval005,cn,vn,vn,vh,
239: hr_pump_get.gl(l.pval005,'SG_ACCOUNT_TYPE',d(l.pval001),l.pval043)) p5,
240: l.pval005 d5,
241: decode(l.pval006,cn,vn,vn,vh,
242: hr_pump_get.gl(l.pval006,'SG_BANK_CODE',d(l.pval001),l.pval043)) p6,
243: l.pval006 d6,

Line 242: hr_pump_get.gl(l.pval006,'SG_BANK_CODE',d(l.pval001),l.pval043)) p6,

238: decode(l.pval005,cn,vn,vn,vh,
239: hr_pump_get.gl(l.pval005,'SG_ACCOUNT_TYPE',d(l.pval001),l.pval043)) p5,
240: l.pval005 d5,
241: decode(l.pval006,cn,vn,vn,vh,
242: hr_pump_get.gl(l.pval006,'SG_BANK_CODE',d(l.pval001),l.pval043)) p6,
243: l.pval006 d6,
244: decode(l.pval007,cn,vn,vn,vh,l.pval007) p7,
245: l.pval007 d7,
246: decode(l.pval008,cn,vn,vn,vh,l.pval008) p8,

Line 301: hr_pump_get.gl(l.pval035,'PAYEE_TYPE',d(l.pval001),l.pval043)) p35,

297: l.pval033 d33,
298: decode(l.pval034,cn,vn,vn,vh,l.pval034) p34,
299: l.pval034 d34,
300: decode(l.pval035,cn,vn,vn,vh,
301: hr_pump_get.gl(l.pval035,'PAYEE_TYPE',d(l.pval001),l.pval043)) p35,
302: l.pval035 d35,
303: l.pval036 p36,
304: l.pval037 p37,
305: decode(l.pval038,cn,dn,d(l.pval038)) p38,

Line 339: hr_pump_get.get_personal_payment_method_id

335: if c.p40 is null then
336: L_PERSONAL_PAYMENT_METHOD_ID:=nn;
337: else
338: L_PERSONAL_PAYMENT_METHOD_ID :=
339: hr_pump_get.get_personal_payment_method_id
340: (P_PERSONAL_PAY_METHOD_USER_KEY => c.p40);
341: end if;
342: --
343: if c.p40 is null or

Line 348: hr_pump_get.GET_PPM_OVN

344: c.p1 is null then
345: L_OBJECT_VERSION_NUMBER:=nn;
346: else
347: L_OBJECT_VERSION_NUMBER :=
348: hr_pump_get.GET_PPM_OVN
349: (P_PERSONAL_PAY_METHOD_USER_KEY => c.p40
350: ,P_EFFECTIVE_DATE => c.p1);
351: end if;
352: --

Line 354: hr_pump_get.get_payee_id

350: ,P_EFFECTIVE_DATE => c.p1);
351: end if;
352: --
353: L_PAYEE_ID :=
354: hr_pump_get.get_payee_id
355: (P_DATA_PUMP_ALWAYS_CALL => null
356: ,P_PAYEE_TYPE => c.p35
357: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID
358: ,P_PAYEE_ORG => c.p41