[Home] [Help]
20: 'TAX_OFFICE_CODE_A=P', hoi1.org_information9,
21: 'PRIMARY_BP_NUMBER=P', hoi2.org_information2,
22: 'CORP_NAME=P', hoi3.org_information1,
23: 'B_RECORDS=P', to_char(g_b_records),
24: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
25: from hr_organization_information hoi3,
26: hr_organization_units corp,
27: hr_organization_information hoi2,
28: hr_organization_information hoi1,
27: hr_organization_information hoi2,
28: hr_organization_information hoi1,
29: hr_all_organization_units_tl bptl,
30: hr_organization_units bp
31: where bp.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
32: and bptl.organization_id = bp.organization_id
33: and bptl.language = userenv('LANG')
34: and hoi1.organization_id = bp.organization_id
35: and hoi1.org_information_context = 'KR_INCOME_TAX_OFFICE'
54: hr_all_organization_units_tl bptl2,
55: hr_organization_units bp2,
56: hr_organization_information hoi1,
57: hr_organization_units bp1
58: where bp1.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
59: and hoi1.organization_id = bp1.organization_id
60: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
61: and bp2.business_group_id = bp1.business_group_id
62: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
58: where bp1.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
59: and hoi1.organization_id = bp1.organization_id
60: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
61: and bp2.business_group_id = bp1.business_group_id
62: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
63: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
64: from PER_ORG_STRUCTURE_ELEMENTS posev
65: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
66: and exists ( select null
61: and bp2.business_group_id = bp1.business_group_id
62: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
63: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
64: from PER_ORG_STRUCTURE_ELEMENTS posev
65: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
66: and exists ( select null
67: from hr_organization_information
68: where organization_id = posev.ORGANIZATION_ID_child
69: and org_information_context = 'CLASS'
68: where organization_id = posev.ORGANIZATION_ID_child
69: and org_information_context = 'CLASS'
70: and org_information1 = 'KR_BUSINESS_PLACE'
71: )
72: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))
73: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
74: )
75: )
76: or (hoi2.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
72: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))
73: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
74: )
75: )
76: or (hoi2.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
77: )
78: )
79: )
80: and hoi2.organization_id = bp2.organization_id
100: and paa.tax_unit_id = bp2.organization_id
101: and paa.action_status = 'C')
102: order by 4;
103:
104: cursor csr_b_summary(p_bp_number varchar2 default pay_magtape_generic.get_parameter_value('BP_NUMBER'),p_tax_office_code varchar2 default pay_magtape_generic.get_parameter_value('TAX_OFFICE_CODE')) is
105: select
106: 'PAYROLL_ID=C', to_char(ppa.payroll_id),
107: 'PAYROLL_ACTION_ID=C', to_char(ppa.payroll_action_id),
108: 'ASSIGN_ID=C', to_char(paa.assignment_id),
156: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year)
157: order by 8;
158:
159:
160: cursor csr_c(p_asg_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGN_ID'),p_effective_date date default fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))) is
161: select
162: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
163: 'NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(pp.national_identifier),
164: 'K', '1',
188: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year
189: order by 2,8,10;
190:
191:
192: cursor csr_d(p_asg_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGN_ID')) is
193: select 'DONATION_CODE=P', pae.aei_information5,
194: 'RECIPIENT_REG_NUM=P', pae.aei_information7,
195: 'RECIPIENT_NAME=P', pae.aei_information8,
196: 'RELATIONSHIP=P', pae.aei_information12,