DBA Data[Home] [Help]

APPS.PAY_KR_SPAY_EFILE dependencies on PAY_KR_SPAY_EFILE_FUN_PKG

Line 189: pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),0)) TOTALTAX

185: ,'TOTAL_RTAX=P'
186: ,SUM(decode(fue.user_entity_name,'A_GROSS_RTAX_ASG_RUN',fai.value,0)) RTAX
187: ,'TOTAL_TAX=P'
188: ,SUM(decode(fue.user_entity_name ,'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN', -- 5652360
189: pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),0)) TOTALTAX
190: ,'EMPLOYEE_COUNT=P'
191: ,sum(decode(decode(fue.user_entity_name ,'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN',fai.value,0),0,0,1)) EMPCOUNT
192: ,'PREV_EMP_COUNT=P'
193: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT

Line 292: ,nvl(pay_kr_spay_efile_fun_pkg.get_prev_emp_count(xpaa.assignment_action_id),0)

288: -- Bug 4253329
289: ,'ASG_ID=P'
290: ,xpaa.assignment_id
291: ,'PREVIOUS_EMP_COUNT=P'
292: ,nvl(pay_kr_spay_efile_fun_pkg.get_prev_emp_count(xpaa.assignment_action_id),0)
293: ,'SRS_START_DATE=P'
294: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('START_DATE'))
295: ,'SRS_END_DATE=P'
296: ,fnd_date.date_to_canonical(pay_magtape_generic.get_parameter_value('END_DATE'))