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_KR_YEA_MAGTAPE_FUN_PKG

Line 62: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),

58:
59: cursor csr_b is
60: select DISTINCT 'BP_NUMBER=P', hoi2.org_information2,
61: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
62: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
63: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
64: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),

Line 63: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),

59: cursor csr_b is
60: select DISTINCT 'BP_NUMBER=P', hoi2.org_information2,
61: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
62: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
63: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
64: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')

Line 64: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),

60: select DISTINCT 'BP_NUMBER=P', hoi2.org_information2,
61: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
62: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
63: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
64: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')
68: from hr_organization_information hoi3,

Line 65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),

61: 'TAX_OFFICE_CODE=P', hoi3.org_information9,
62: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
63: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
64: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')
68: from hr_organization_information hoi3,
69: hr_organization_information hoi2,

Line 66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),

62: 'C_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'C_RECORDS'),
63: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
64: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')
68: from hr_organization_information hoi3,
69: hr_organization_information hoi2,
70: hr_all_organization_units_tl bptl2,

Line 67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')

63: 'TAXABLE=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'TAXABLE'),
64: 'ANNUAL_ITAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_ITAX'),
65: 'ANNUAL_RTAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_RTAX'),
66: 'ANNUAL_STAX=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'ANNUAL_STAX'),
67: 'D_RECORDS=P', pay_kr_yea_magtape_fun_pkg.b_data(hoi2.org_information2, hoi3.org_information9, 'D_RECORDS')
68: from hr_organization_information hoi3,
69: hr_organization_information hoi2,
70: hr_all_organization_units_tl bptl2,
71: hr_organization_units bp2,

Line 134: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),

130: 'NATIONAL_IDENTIFIER=P', pp.national_identifier,
131: 'FULL_NAME=P', pp.last_name || pp.first_name,
132: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),
133: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),
134: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),
135: 'COUNTRY_CODE=P', pp.country_of_birth,
136: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) -- 4738717
137: from per_people_f pp,
138: per_periods_of_service pds,

Line 136: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) -- 4738717

132: 'HIRE_DATE=P', fnd_date.date_to_canonical(pds.date_start),
133: 'TERMINATION_DATE=P', fnd_date.date_to_canonical(pds.actual_termination_date),
134: 'D_RECORDS_PER_C=P', pay_kr_yea_magtape_fun_pkg.c_data(paa.assignment_id, 'D_RECORDS_PER_C'),
135: 'COUNTRY_CODE=P', pp.country_of_birth,
136: 'DEPENDENT_COUNT=P', pay_kr_yea_magtape_fun_pkg.e_record_count(paa.assignment_id,ppa.effective_date) -- 4738717
137: from per_people_f pp,
138: per_periods_of_service pds,
139: per_assignments_f pa,
140: pay_assignment_actions paa,

Line 164: and ((g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, g_payroll_action_id, g_target_year) = 'Y')) -- Bug 4726974

160: and paa.payroll_action_id = ppa.payroll_action_id
161: and ppa.payroll_action_id = ppa.payroll_action_id
162: -- Bug 3248513
163: and ((g_assignment_set_id is null) or (hr_assignment_set.assignment_in_set(g_assignment_set_id, paa.assignment_id) = 'Y'))
164: and ((g_re_yea <> 'R') or (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, g_payroll_action_id, g_target_year) = 'Y')) -- Bug 4726974
165: --
166: and paa.tax_unit_id = bp.organization_id
167: and paa.action_status = 'C'
168: and pa.assignment_id = paa.assignment_id

Line 194: -- pay_kr_yea_magtape_fun_pkg.e_record_count also.

190: order by aei_information1, 2;
191: ------------------------------------------------------------------------
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'))