[Home] [Help]
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,
29: hr_all_organization_units_tl bptl,
30: hr_organization_units bp
26: hr_organization_units corp,
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
51: 'REP_PERIOD_CODE=P', g_rep_period_code
52: from hr_organization_information hoi3,
53: hr_organization_information hoi2,
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
53: hr_organization_information hoi2,
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
112: 'EFFECTIVE_DATE=P', fnd_date.date_to_canonical(ppa.effective_date)
113: from per_assignments_f pa,
114: pay_assignment_actions paa,
115: pay_payroll_actions ppa,
116: hr_organization_units bp,
117: hr_organization_information hoi1,
118: hr_organization_information hoi2
119: where hoi1.org_information2 = p_bp_number
120: and hoi2.org_information9 = p_tax_office_code