APPS.PAY_NL_IZA_REPORT dependencies on PAY_NL_IZA_UPLD_STATUS

Line 32: from pay_nl_iza_upld_status iza

28: cursor csr_employer_data is
29: select 'EUR' currency , iza.payroll_center ,
30: iza.province_code||' '||hr_general.decode_lookup('NL_IZA_PROVINCE',iza.province_code) province,
31: lpad(employer_number,3,'0') employer_number , lpad(sub_employer_number,3,'0') sub_employer_number
32: from pay_nl_iza_upld_status iza
33: where iza.business_group_id = p_bg_id
34: and iza.organization_id = p_employer_id
35: and iza.process_year_month = last_day(to_date(p_process_month,'MMYYYY'));
36:

Line 46: from pay_nl_iza_upld_status iza

42: iza.contribution_1 iza_amt_1,iza.contribution_2 iza_amt_2,
43: iza.correction_contribution_1 corr_amt_1,iza.correction_contribution_2 corr_amt_2,
44: iza.date_correction_1,iza.date_correction_2,
45: decode(iza.process_status,'MISSING',hr_general.decode_lookup('NL_IZA_REJECT_REASON',iza.process_status),hr_general.decode_lookup('NL_IZA_REJECT_REASON',iza.reject_reason)) explanation
46: from pay_nl_iza_upld_status iza
47: where iza.business_group_id = p_bg_id
48: and iza.organization_id = p_employer_id
49: and iza.process_year_month = last_day(to_date(p_process_month,'MMYYYY'));
50: