DBA Data[Home] [Help]

APPS.HRDPP_MX_FINAL_PROCESS_EMP dependencies on HR_PUMP_GET

Line 122: hr_pump_get.gl(l.pval001,'MX_STAT_IMSS_LEAVING_REASON',dn,vn)) p1,

118: p_batch_line_id in number) is
119: cursor cr is
120: select l.rowid myrowid,
121: decode(l.pval001,cn,vn,vn,vh,
122: hr_pump_get.gl(l.pval001,'MX_STAT_IMSS_LEAVING_REASON',dn,vn)) p1,
123: l.pval001 d1,
124: decode(l.pval002,cn,dn,d(l.pval002)) p2,
125: l.pval003 p3,
126: l.pval004 p4,

Line 155: hr_pump_get.GET_FP_PERIOD_OF_SERVICE_ID

151: if c.p6 is null then
152: L_PERIOD_OF_SERVICE_ID:=nn;
153: else
154: L_PERIOD_OF_SERVICE_ID :=
155: hr_pump_get.GET_FP_PERIOD_OF_SERVICE_ID
156: (P_PERSON_USER_KEY => c.p6
157: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
158: end if;
159: --

Line 164: hr_pump_get.GET_FP_PERIOD_OF_SERVICE_OVN

160: if c.p6 is null then
161: L_OBJECT_VERSION_NUMBER:=nn;
162: else
163: L_OBJECT_VERSION_NUMBER :=
164: hr_pump_get.GET_FP_PERIOD_OF_SERVICE_OVN
165: (P_PERSON_USER_KEY => c.p6
166: ,P_BUSINESS_GROUP_ID => P_BUSINESS_GROUP_ID);
167: end if;
168: --