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_YEA_MAGTAPE_PKG dependencies on PAY_MAGTAPE_GENERIC

Line 35: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')

31: 'CORP_NUMBER=P', hoi3.org_information2,
32: 'CORP_REPR_NAME=P', hoi3.org_information6,
33: 'CORP_PHONE_NUMBER=P', loc.telephone_number_1,
34: 'B_RECORDS=P', to_char(g_b_records),
35: 'HOME_TAX_ID=P', nvl(pay_magtape_generic.get_parameter_value('HOME_TAX_ID'), ' ')
36: from hr_organization_information hoi3,
37: hr_locations_all loc,
38: hr_all_organization_units_tl corptl,
39: hr_organization_units corp,

Line 74: where bp1.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID') --Bug 5069923

70: hr_all_organization_units_tl bptl2,
71: hr_organization_units bp2,
72: hr_organization_information hoi1,
73: hr_organization_units bp1
74: where bp1.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID') --Bug 5069923
75: and hoi1.organization_id = bp1.organization_id
76: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
77: and bp2.business_group_id = bp1.business_group_id
78: --Bug 5069923

Line 79: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')

75: and hoi1.organization_id = bp1.organization_id
76: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
77: and bp2.business_group_id = bp1.business_group_id
78: --Bug 5069923
79: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
80: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
81: from PER_ORG_STRUCTURE_ELEMENTS posev
82: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
83: and exists ( select null

Line 82: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))

78: --Bug 5069923
79: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
80: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
81: from PER_ORG_STRUCTURE_ELEMENTS posev
82: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
83: and exists ( select null
84: from hr_organization_information
85: where organization_id = posev.ORGANIZATION_ID_child
86: and org_information_context = 'CLASS'

Line 89: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')))

85: where organization_id = posev.ORGANIZATION_ID_child
86: and org_information_context = 'CLASS'
87: and org_information1 = 'KR_BUSINESS_PLACE'
88: )
89: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')))
90: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
91: )
92: )
93: or (hoi2.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')

Line 93: or (hoi2.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')

89: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')))
90: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
91: )
92: )
93: or (hoi2.organization_id = pay_magtape_generic.get_parameter_value('BUSINESS_PLACE_ID')
94: )
95: )
96: )
97: and hoi2.organization_id = bp2.organization_id

Line 121: cursor csr_c(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

117: and paa.tax_unit_id = bp2.organization_id
118: and paa.action_status = 'C')
119: order by 4;
120:
121: cursor csr_c(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
122: select
123: 'PAYROLL_ID=C', to_char(ppa.payroll_id),
124: 'PAYROLL_ACTION_ID=C', to_char(ppa.payroll_action_id),
125: 'ASSIGNMENT_ID=C', to_char(paa.assignment_id),

Line 178: cursor csr_d(p_assignment_id number default to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'))) is

174: and ppa.effective_date
175: between pp.effective_start_date and pp.effective_end_date
176: order by 16;
177:
178: cursor csr_d(p_assignment_id number default to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'))) is
179: select
180: 'PREV_BP_NUMBER=P', aei.aei_information3,
181: 'PREV_BP_NAME=P', aei.aei_information2,
182: 'PREV_TAXABLE_MTH=P', nvl(aei.aei_information4, 0),

Line 196: cursor csr_e( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),

192:
193: -- Note: Any change in this cursor must be included in
194: -- pay_kr_yea_magtape_fun_pkg.e_record_count also.
195:
196: cursor csr_e( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),
197: p_effective_date date default fnd_date.canonical_to_date(
198: pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))
199: ) is
200: -- Bug 5654127

Line 198: pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))

194: -- pay_kr_yea_magtape_fun_pkg.e_record_count also.
195:
196: cursor csr_e( p_assignment_id varchar2 default pay_magtape_generic.get_parameter_value('ASSIGNMENT_ID'),
197: p_effective_date date default fnd_date.canonical_to_date(
198: pay_magtape_generic.get_parameter_value('EFFECTIVE_DATE'))
199: ) is
200: -- Bug 5654127
201: select 'CONTACT_TYPE=P', '0' contact_type,
202: 'NATIONALITY=P', decode(pay_kr_ff_functions_pkg.ni_nationality(asg.assignment_id,p_effective_date),'K','1','9') nationality,