DBA Data[Home] [Help]

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PAY_KR_SPAY_EFILE_FUN_PKG

Line 187: 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN', pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),

183: ,SUM(decode(fue.user_entity_name,'A_GROSS_RTAX_ASG_RUN',fai.value,0)) RTAX
184: ,'TOTAL_TAXABLE_EARNG=P'
185: --Bug 5659556
186: ,SUM(decode(fue.user_entity_name,
187: 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN', pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),
188: 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN', fai.value, 0)) TAXABLE_EARNG
189: --
190: ,'EMPLOYEE_COUNT=P'
191: ,sum(decode(decode(fue.user_entity_name ,'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN',fai.value,0),0,0,1)) EMPCOUNT