APPS.PAY_PYSG8SAD_XMLP_PKG dependencies on PAY_BALANCE_PKG

Line 101: PAY_BALANCE_PKG.SET_CONTEXT

97:
98: IF assignment_action_id IS NOT NULL THEN
99: BEGIN
100:
101: PAY_BALANCE_PKG.SET_CONTEXT
102: ( P_CONTEXT_NAME => 'ASSIGNMENT_ACTION_ID'
103: ,P_CONTEXT_VALUE => assignment_action_id );
104: PAY_BALANCE_PKG.SET_CONTEXT
105: ( P_CONTEXT_NAME => 'TAX_UNIT_ID'

Line 104: PAY_BALANCE_PKG.SET_CONTEXT

100:
101: PAY_BALANCE_PKG.SET_CONTEXT
102: ( P_CONTEXT_NAME => 'ASSIGNMENT_ACTION_ID'
103: ,P_CONTEXT_VALUE => assignment_action_id );
104: PAY_BALANCE_PKG.SET_CONTEXT
105: ( P_CONTEXT_NAME => 'TAX_UNIT_ID'
106: ,P_CONTEXT_VALUE => P_LEGAL_ENTITY );
107: PAY_BALANCE_PKG.SET_CONTEXT
108: ( P_CONTEXT_NAME => 'DATE_EARNED'

Line 107: PAY_BALANCE_PKG.SET_CONTEXT

103: ,P_CONTEXT_VALUE => assignment_action_id );
104: PAY_BALANCE_PKG.SET_CONTEXT
105: ( P_CONTEXT_NAME => 'TAX_UNIT_ID'
106: ,P_CONTEXT_VALUE => P_LEGAL_ENTITY );
107: PAY_BALANCE_PKG.SET_CONTEXT
108: ( P_CONTEXT_NAME => 'DATE_EARNED'
109: ,P_CONTEXT_VALUE => date_earned );
110:
111: CP_OW := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

Line 111: CP_OW := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

107: PAY_BALANCE_PKG.SET_CONTEXT
108: ( P_CONTEXT_NAME => 'DATE_EARNED'
109: ,P_CONTEXT_VALUE => date_earned );
110:
111: CP_OW := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
112: ( P_DATABASE_NAME => 'X_ORDINARY_EARNINGS_PER_LE_MONTH'
113: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
114: ,P_LEGISLATION_CODE => 'SG' ));
115:

Line 116: CP_OW_CPF_ER := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

112: ( P_DATABASE_NAME => 'X_ORDINARY_EARNINGS_PER_LE_MONTH'
113: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
114: ,P_LEGISLATION_CODE => 'SG' ));
115:
116: CP_OW_CPF_ER := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
117: ( P_DATABASE_NAME => 'X_EMPLOYER_CPF_CONTRIBUTIONS_ORDINARY_EARNINGS_PER_LE_MONTH'
118: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
119: ,P_LEGISLATION_CODE => 'SG' ));
120: CP_OW_CPF_EE := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

Line 120: CP_OW_CPF_EE := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

116: CP_OW_CPF_ER := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
117: ( P_DATABASE_NAME => 'X_EMPLOYER_CPF_CONTRIBUTIONS_ORDINARY_EARNINGS_PER_LE_MONTH'
118: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
119: ,P_LEGISLATION_CODE => 'SG' ));
120: CP_OW_CPF_EE := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
121: ( P_DATABASE_NAME => 'X_EMPLOYEE_CPF_CONTRIBUTIONS_ORDINARY_EARNINGS_PER_LE_MONTH'
122: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
123: ,P_LEGISLATION_CODE => 'SG' ));
124: CP_OW_APR_FUND := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

Line 124: CP_OW_APR_FUND := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

120: CP_OW_CPF_EE := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
121: ( P_DATABASE_NAME => 'X_EMPLOYEE_CPF_CONTRIBUTIONS_ORDINARY_EARNINGS_PER_LE_MONTH'
122: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
123: ,P_LEGISLATION_CODE => 'SG' ));
124: CP_OW_APR_FUND := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
125: ( P_DATABASE_NAME => 'X_IR8S_MOA_403_PER_LE_MONTH'
126: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
127: ,P_LEGISLATION_CODE => 'SG' ));
128: CP_AW := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

Line 128: CP_AW := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

124: CP_OW_APR_FUND := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
125: ( P_DATABASE_NAME => 'X_IR8S_MOA_403_PER_LE_MONTH'
126: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
127: ,P_LEGISLATION_CODE => 'SG' ));
128: CP_AW := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
129: ( P_DATABASE_NAME => 'X_ADDITIONAL_EARNINGS_PER_LE_MONTH'
130: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
131: ,P_LEGISLATION_CODE => 'SG' ));
132:

Line 133: CP_AW_CPF_ER := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

129: ( P_DATABASE_NAME => 'X_ADDITIONAL_EARNINGS_PER_LE_MONTH'
130: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
131: ,P_LEGISLATION_CODE => 'SG' ));
132:
133: CP_AW_CPF_ER := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
134: ( P_DATABASE_NAME => 'X_EMPLOYER_CPF_CONTRIBUTIONS_ADDITIONAL_EARNINGS_PER_LE_MONTH'
135: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
136: ,P_LEGISLATION_CODE => 'SG' ));
137:

Line 138: CP_AW_CPF_EE := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

134: ( P_DATABASE_NAME => 'X_EMPLOYER_CPF_CONTRIBUTIONS_ADDITIONAL_EARNINGS_PER_LE_MONTH'
135: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
136: ,P_LEGISLATION_CODE => 'SG' ));
137:
138: CP_AW_CPF_EE := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
139: ( P_DATABASE_NAME => 'X_EMPLOYEE_CPF_CONTRIBUTIONS_ADDITIONAL_EARNINGS_PER_LE_MONTH'
140: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
141: ,P_LEGISLATION_CODE => 'SG' ));
142:

Line 143: CP_AW_APR_FUND := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM

139: ( P_DATABASE_NAME => 'X_EMPLOYEE_CPF_CONTRIBUTIONS_ADDITIONAL_EARNINGS_PER_LE_MONTH'
140: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
141: ,P_LEGISLATION_CODE => 'SG' ));
142:
143: CP_AW_APR_FUND := to_number(PAY_BALANCE_PKG.RUN_DB_ITEM
144: ( P_DATABASE_NAME => 'X_IR8S_MOA_407_PER_LE_MONTH'
145: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
146: ,P_LEGISLATION_CODE => 'SG' ));
147:

Line 169: PAY_BALANCE_PKG.SET_CONTEXT

165:
166: BEGIN
167: BEGIN
168:
169: PAY_BALANCE_PKG.SET_CONTEXT
170: ( P_CONTEXT_NAME => 'ASSIGNMENT_ACTION_ID'
171: ,P_CONTEXT_VALUE => ASSIGNMENT_ACTION_ID2 );
172: PAY_BALANCE_PKG.SET_CONTEXT
173: ( P_CONTEXT_NAME => 'TAX_UNIT_ID'

Line 172: PAY_BALANCE_PKG.SET_CONTEXT

168:
169: PAY_BALANCE_PKG.SET_CONTEXT
170: ( P_CONTEXT_NAME => 'ASSIGNMENT_ACTION_ID'
171: ,P_CONTEXT_VALUE => ASSIGNMENT_ACTION_ID2 );
172: PAY_BALANCE_PKG.SET_CONTEXT
173: ( P_CONTEXT_NAME => 'TAX_UNIT_ID'
174: ,P_CONTEXT_VALUE => P_LEGAL_ENTITY );
175: PAY_BALANCE_PKG.SET_CONTEXT
176: ( P_CONTEXT_NAME => 'SOURCE_ID'

Line 175: PAY_BALANCE_PKG.SET_CONTEXT

171: ,P_CONTEXT_VALUE => ASSIGNMENT_ACTION_ID2 );
172: PAY_BALANCE_PKG.SET_CONTEXT
173: ( P_CONTEXT_NAME => 'TAX_UNIT_ID'
174: ,P_CONTEXT_VALUE => P_LEGAL_ENTITY );
175: PAY_BALANCE_PKG.SET_CONTEXT
176: ( P_CONTEXT_NAME => 'SOURCE_ID'
177: ,P_CONTEXT_VALUE => ASS_EXTRA_ID );
178:
179: CP_AW_AMT := PAY_BALANCE_PKG.RUN_DB_ITEM

Line 179: CP_AW_AMT := PAY_BALANCE_PKG.RUN_DB_ITEM

175: PAY_BALANCE_PKG.SET_CONTEXT
176: ( P_CONTEXT_NAME => 'SOURCE_ID'
177: ,P_CONTEXT_VALUE => ASS_EXTRA_ID );
178:
179: CP_AW_AMT := PAY_BALANCE_PKG.RUN_DB_ITEM
180: ( P_DATABASE_NAME => 'X_MOA410'
181: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
182: ,P_LEGISLATION_CODE => 'SG' );
183:

Line 184: l_aw_fr_date := PAY_BALANCE_PKG.RUN_DB_ITEM

180: ( P_DATABASE_NAME => 'X_MOA410'
181: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
182: ,P_LEGISLATION_CODE => 'SG' );
183:
184: l_aw_fr_date := PAY_BALANCE_PKG.RUN_DB_ITEM
185: ( P_DATABASE_NAME => 'X_DTM502'
186: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
187: ,P_LEGISLATION_CODE => 'SG' );
188: CP_AW_FR_DATE := to_char(fnd_date.canonical_to_date(l_aw_fr_date),'DD-MON-YYYY');

Line 190: l_aw_to_date := PAY_BALANCE_PKG.RUN_DB_ITEM

186: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
187: ,P_LEGISLATION_CODE => 'SG' );
188: CP_AW_FR_DATE := to_char(fnd_date.canonical_to_date(l_aw_fr_date),'DD-MON-YYYY');
189:
190: l_aw_to_date := PAY_BALANCE_PKG.RUN_DB_ITEM
191: ( P_DATABASE_NAME => 'X_DTM503'
192: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
193: ,P_LEGISLATION_CODE => 'SG' );
194: CP_AW_TO_DATE := to_char(fnd_date.canonical_to_date(l_aw_fr_date),'DD-MON-YYYY');

Line 196: l_refund_date := PAY_BALANCE_PKG.RUN_DB_ITEM

192: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
193: ,P_LEGISLATION_CODE => 'SG' );
194: CP_AW_TO_DATE := to_char(fnd_date.canonical_to_date(l_aw_fr_date),'DD-MON-YYYY');
195:
196: l_refund_date := PAY_BALANCE_PKG.RUN_DB_ITEM
197: ( P_DATABASE_NAME => 'X_DTM504'
198: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
199: ,P_LEGISLATION_CODE => 'SG' );
200: CP_REFUND_DATE := to_char(fnd_date.canonical_to_date(l_refund_date),'DD-MON-YYYY');

Line 202: CP_ER_CONTRIB := PAY_BALANCE_PKG.RUN_DB_ITEM

198: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
199: ,P_LEGISLATION_CODE => 'SG' );
200: CP_REFUND_DATE := to_char(fnd_date.canonical_to_date(l_refund_date),'DD-MON-YYYY');
201:
202: CP_ER_CONTRIB := PAY_BALANCE_PKG.RUN_DB_ITEM
203: ( P_DATABASE_NAME => 'X_MOA411'
204: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
205: ,P_LEGISLATION_CODE => 'SG' );
206:

Line 207: CP_ER_INTR := PAY_BALANCE_PKG.RUN_DB_ITEM

203: ( P_DATABASE_NAME => 'X_MOA411'
204: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
205: ,P_LEGISLATION_CODE => 'SG' );
206:
207: CP_ER_INTR := PAY_BALANCE_PKG.RUN_DB_ITEM
208: ( P_DATABASE_NAME => 'X_MOA412'
209: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
210: ,P_LEGISLATION_CODE => 'SG' );
211:

Line 212: l_er_date := PAY_BALANCE_PKG.RUN_DB_ITEM

208: ( P_DATABASE_NAME => 'X_MOA412'
209: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
210: ,P_LEGISLATION_CODE => 'SG' );
211:
212: l_er_date := PAY_BALANCE_PKG.RUN_DB_ITEM
213: ( P_DATABASE_NAME => 'X_DTM505'
214: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
215: ,P_LEGISLATION_CODE => 'SG' );
216: CP_ER_DATE := to_char(fnd_date.canonical_to_date(l_er_date),'DD-MON-YYYY');

Line 218: CP_EE_CONTRIB := PAY_BALANCE_PKG.RUN_DB_ITEM

214: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
215: ,P_LEGISLATION_CODE => 'SG' );
216: CP_ER_DATE := to_char(fnd_date.canonical_to_date(l_er_date),'DD-MON-YYYY');
217:
218: CP_EE_CONTRIB := PAY_BALANCE_PKG.RUN_DB_ITEM
219: ( P_DATABASE_NAME => 'X_MOA413'
220: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
221: ,P_LEGISLATION_CODE => 'SG' );
222:

Line 223: CP_EE_INTR := PAY_BALANCE_PKG.RUN_DB_ITEM

219: ( P_DATABASE_NAME => 'X_MOA413'
220: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
221: ,P_LEGISLATION_CODE => 'SG' );
222:
223: CP_EE_INTR := PAY_BALANCE_PKG.RUN_DB_ITEM
224: ( P_DATABASE_NAME => 'X_MOA414'
225: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
226: ,P_LEGISLATION_CODE => 'SG' );
227:

Line 228: l_ee_date := PAY_BALANCE_PKG.RUN_DB_ITEM

224: ( P_DATABASE_NAME => 'X_MOA414'
225: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
226: ,P_LEGISLATION_CODE => 'SG' );
227:
228: l_ee_date := PAY_BALANCE_PKG.RUN_DB_ITEM
229: ( P_DATABASE_NAME => 'X_DTM506'
230: ,P_BUS_GROUP_ID => P_BUSINESS_GROUP_ID
231: ,P_LEGISLATION_CODE => 'SG' );
232: CP_EE_DATE := to_char(fnd_date.canonical_to_date(l_ee_date),'DD-MON-YYYY');