eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PAY_KR_SPAY_EFILE_FUN_PKG

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

190: ,SUM(decode(fue.user_entity_name,'A_GROSS_RTAX_ASG_RUN',fai.value,0)) RTAX
191: ,'TOTAL_TAXABLE_EARNG=P'
192: --Bug 5659556
193: ,SUM(decode(fue.user_entity_name,
194: 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN', pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),
195: 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN',pay_kr_spay_efile_fun_pkg.get_nsep_pay_amount(xpaa.assignment_action_id,fai.value), 0)) TAXABLE_EARNG
196: --
197: , 'TS_REC_SEP_PAY=P'
198: , SUM(decode(fue.user_entity_name,'A_RECEIVABLE_SEPARATION_PAY_ASG_RUN',fai.value,0)) SEPPAYAMT

Line 195: 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN',pay_kr_spay_efile_fun_pkg.get_nsep_pay_amount(xpaa.assignment_action_id,fai.value), 0)) TAXABLE_EARNG

191: ,'TOTAL_TAXABLE_EARNG=P'
192: --Bug 5659556
193: ,SUM(decode(fue.user_entity_name,
194: 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN', pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),
195: 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN',pay_kr_spay_efile_fun_pkg.get_nsep_pay_amount(xpaa.assignment_action_id,fai.value), 0)) TAXABLE_EARNG
196: --
197: , 'TS_REC_SEP_PAY=P'
198: , SUM(decode(fue.user_entity_name,'A_RECEIVABLE_SEPARATION_PAY_ASG_RUN',fai.value,0)) SEPPAYAMT
199: , 'TS_EARNINS=P'

Line 235: 'A_FULL_DEF_TAXABLE_EARNINGS_ASG_RUN', pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),

231: , 'TS_PRE_SEP_ENT=P'
232: , SUM(decode(fue.user_entity_name,'A_PREV_SEP_PENS_DTLS_AMT_EXP_NONSTAT_SEP_ENTRY_VALUE',fai.value,0)) PRESEPENT
233: , 'TS_FULL_DEF_EARN=P'
234: ,SUM(decode(fue.user_entity_name,
235: 'A_FULL_DEF_TAXABLE_EARNINGS_ASG_RUN', pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),
236: 'A_FULL_DEF_NS_EARNINGS_ASG_RUN',pay_kr_spay_efile_fun_pkg.get_nsep_pay_amount(xpaa.assignment_action_id,fai.value), 0)) FULLDEFEARN
237: , 'TS_DEF_TAX=P'
238: , SUM(decode(fue.user_entity_name,'A_DEFERRED_TAX_AMOUNT_ASG_RUN',fai.value,0)) DEFTAX
239: ,'TS_PREV_SEP_PAY=P'

Line 236: 'A_FULL_DEF_NS_EARNINGS_ASG_RUN',pay_kr_spay_efile_fun_pkg.get_nsep_pay_amount(xpaa.assignment_action_id,fai.value), 0)) FULLDEFEARN

232: , SUM(decode(fue.user_entity_name,'A_PREV_SEP_PENS_DTLS_AMT_EXP_NONSTAT_SEP_ENTRY_VALUE',fai.value,0)) PRESEPENT
233: , 'TS_FULL_DEF_EARN=P'
234: ,SUM(decode(fue.user_entity_name,
235: 'A_FULL_DEF_TAXABLE_EARNINGS_ASG_RUN', pay_kr_spay_efile_fun_pkg.get_sep_pay_amount(xpaa.assignment_action_id,fai.value),
236: 'A_FULL_DEF_NS_EARNINGS_ASG_RUN',pay_kr_spay_efile_fun_pkg.get_nsep_pay_amount(xpaa.assignment_action_id,fai.value), 0)) FULLDEFEARN
237: , 'TS_DEF_TAX=P'
238: , SUM(decode(fue.user_entity_name,'A_DEFERRED_TAX_AMOUNT_ASG_RUN',fai.value,0)) DEFTAX
239: ,'TS_PREV_SEP_PAY=P'
240: ,SUM(decode(fue.user_entity_name,'X_KR_PREV_SEP_PAY',fai.value,0)) PREVSEPPAY

Line 250: ,sum(decode(pay_kr_spay_efile_fun_pkg.get_emp_count(fue.user_entity_name,xpaa.assignment_action_id),0,0,1 )) EMPCOUNT -- Bug 9409509

246: ,SUM(decode(fue.user_entity_name,'X_KR_PREV_LUMP_SUM_STAT_ENT',fai.value,0)) PREVLUMPSUM
247: ,'TS_PREV_NS_LUMP_SUM=P'
248: ,SUM(decode(fue.user_entity_name,'X_KR_PREV_LUMP_SUM_NST_ENT',fai.value,0)) PREVNSLUMPSUM
249: ,'EMPLOYEE_COUNT=P'
250: ,sum(decode(pay_kr_spay_efile_fun_pkg.get_emp_count(fue.user_entity_name,xpaa.assignment_action_id),0,0,1 )) EMPCOUNT -- Bug 9409509
251: ,'PREV_EMP_COUNT=P'
252: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
253: ,'REPORTING_PERIOD=P'
254: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')

Line 322: and fue1.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509

318: --Bug 5069923
319: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
320: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
321: )
322: and fue1.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509
323: and fue1.legislation_code = 'KR'
324: and fai1.user_entity_id = fue1.user_entity_id
325: and fai1.context1 = xpaa.assignment_Action_id
326: and fai1.value > '0';

Line 422: and fue.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509

418: and hoi.org_information2 = pay_magtape_generic.get_parameter_value('BP_NUMBER')
419: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')
420: and hoi.organization_id = hou.organization_id
421: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
422: and fue.user_entity_name = pay_kr_spay_efile_fun_pkg.get_archive_item(xpaa.assignment_Action_id) -- Bug 9409509
423: and fue.legislation_code = 'KR'
424: and fai.user_entity_id = fue.user_entity_id
425: and fai.context1 = xpaa.assignment_action_id
426: --Bug 5069923