APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on PAY_KR_NONSTAT_SPAY_EFILE_FUN

Line 367: ,pay_kr_nonstat_spay_efile_fun.get_prev_emp_count(xpaa.assignment_action_id)

363: -- Bug 4251252
364: ,'ASG_ID=P'
365: ,xpaa.assignment_id
366: ,'PREVIOUS_EMP_COUNT=P'
367: ,pay_kr_nonstat_spay_efile_fun.get_prev_emp_count(xpaa.assignment_action_id)
368: -- Bug 7712932
369: ,'STAT_SEP_PAY_OVR_TAX_BRK=P'
370: ,pay_kr_nonstat_spay_efile_fun.get_sep_pay_ovr_tax_brk(xpaa.assignment_action_id,xpaa.assignment_id,'SEP')
371: ,'NSTAT_SEP_PAY_OVR_TAX_BRK=P'

Line 370: ,pay_kr_nonstat_spay_efile_fun.get_sep_pay_ovr_tax_brk(xpaa.assignment_action_id,xpaa.assignment_id,'SEP')

366: ,'PREVIOUS_EMP_COUNT=P'
367: ,pay_kr_nonstat_spay_efile_fun.get_prev_emp_count(xpaa.assignment_action_id)
368: -- Bug 7712932
369: ,'STAT_SEP_PAY_OVR_TAX_BRK=P'
370: ,pay_kr_nonstat_spay_efile_fun.get_sep_pay_ovr_tax_brk(xpaa.assignment_action_id,xpaa.assignment_id,'SEP')
371: ,'NSTAT_SEP_PAY_OVR_TAX_BRK=P'
372: ,pay_kr_nonstat_spay_efile_fun.get_sep_pay_ovr_tax_brk(xpaa.assignment_action_id,xpaa.assignment_id,'NSEP')
373: -- End of Bug 7712932
374: ,'BP_NUMBER=P'

Line 372: ,pay_kr_nonstat_spay_efile_fun.get_sep_pay_ovr_tax_brk(xpaa.assignment_action_id,xpaa.assignment_id,'NSEP')

368: -- Bug 7712932
369: ,'STAT_SEP_PAY_OVR_TAX_BRK=P'
370: ,pay_kr_nonstat_spay_efile_fun.get_sep_pay_ovr_tax_brk(xpaa.assignment_action_id,xpaa.assignment_id,'SEP')
371: ,'NSTAT_SEP_PAY_OVR_TAX_BRK=P'
372: ,pay_kr_nonstat_spay_efile_fun.get_sep_pay_ovr_tax_brk(xpaa.assignment_action_id,xpaa.assignment_id,'NSEP')
373: -- End of Bug 7712932
374: ,'BP_NUMBER=P'
375: ,hoi.org_information2
376: ,'CORP_NAME=P'

Line 380: ,nvl(pay_kr_report_pkg.get_result_value_char( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),to_number(pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID'))

376: ,'CORP_NAME=P'
377: ,hoi.org_information1
378: /* Bug 10216334 */
379: ,'PREV_SEP_PEN_ACCOUNT_NUMBER=P'
380: ,nvl(pay_kr_report_pkg.get_result_value_char( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),to_number(pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID'))
381: ,'PREV_SEP_PENS_DTLS', 'Account Number'),' ')
382: ,'PREV_HIRING_DATE=P'
383: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
384: 'PREV_FH_DATE', 'WKPD')

Line 383: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),

379: ,'PREV_SEP_PEN_ACCOUNT_NUMBER=P'
380: ,nvl(pay_kr_report_pkg.get_result_value_char( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),to_number(pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID'))
381: ,'PREV_SEP_PENS_DTLS', 'Account Number'),' ')
382: ,'PREV_HIRING_DATE=P'
383: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
384: 'PREV_FH_DATE', 'WKPD')
385: ,'PREV_LEAVING_DATE=P'
386: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
387: 'PREV_LL_DATE', 'WKPD')

Line 386: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),

382: ,'PREV_HIRING_DATE=P'
383: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
384: 'PREV_FH_DATE', 'WKPD')
385: ,'PREV_LEAVING_DATE=P'
386: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
387: 'PREV_LL_DATE', 'WKPD')
388: ,'PREV_HIRING_DATE_NST=P'
389: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
390: 'PREV_FH_DATE','WKPD_NON_STAT_SEP_PAY')

Line 389: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),

385: ,'PREV_LEAVING_DATE=P'
386: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
387: 'PREV_LL_DATE', 'WKPD')
388: ,'PREV_HIRING_DATE_NST=P'
389: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
390: 'PREV_FH_DATE','WKPD_NON_STAT_SEP_PAY')
391: ,'PREV_LEAVING_DATE_NST=P'
392: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
393: 'PREV_LL_DATE', 'WKPD_NON_STAT_SEP_PAY')

Line 392: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),

388: ,'PREV_HIRING_DATE_NST=P'
389: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
390: 'PREV_FH_DATE','WKPD_NON_STAT_SEP_PAY')
391: ,'PREV_LEAVING_DATE_NST=P'
392: ,pay_kr_nonstat_spay_efile_fun.get_element_rr_date_value( pay_kr_nonstat_spay_efile_fun.get_assignment_action_id(xpaa.assignment_action_id,xpaa.assignment_id),
393: 'PREV_LL_DATE', 'WKPD_NON_STAT_SEP_PAY')
394: ,'EFFECTIVE_DATE=P'
395: ,to_char(xppa.effective_date,'YYYY/MM/DD')
396: