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',
192: pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),0),0,0,1)) EMPCOUNT --Bug 9409509
193: ,'PREV_EMP_COUNT=P'

Line 192: pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),0),0,0,1)) EMPCOUNT --Bug 9409509

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',
192: pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),0),0,0,1)) EMPCOUNT --Bug 9409509
193: ,'PREV_EMP_COUNT=P'
194: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
195: FROM pay_assignment_actions xpaa
196: ,pay_payroll_actions xppa

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

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