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

Line 45: bhoi_primary.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

41: hr_organization_information choi,
42: hr_organization_information ihoi,
43: ff_archive_items ar
44: where
45: bhoi_primary.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
46: and bhoi_primary.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
47: and choi.organization_id = to_number(bhoi_primary.org_information10)
48: and choi.org_information_context = 'KR_CORPORATE_INFORMATION'
49: and ihoi.organization_id = bhoi_primary.organization_id

Line 51: and hou1.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')

47: and choi.organization_id = to_number(bhoi_primary.org_information10)
48: and choi.org_information_context = 'KR_CORPORATE_INFORMATION'
49: and ihoi.organization_id = bhoi_primary.organization_id
50: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
51: and hou1.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')
52: and bhoi.organization_id = hou1.organization_id
53: --Bug 5069923
54: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
55: or ( (bhoi.organization_id in ( select posev.ORGANIZATION_ID_child

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

50: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
51: and hou1.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')
52: and bhoi.organization_id = hou1.organization_id
53: --Bug 5069923
54: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
55: or ( (bhoi.organization_id in ( select posev.ORGANIZATION_ID_child
56: from PER_ORG_STRUCTURE_ELEMENTS posev
57: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
58: and exists ( select null

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

53: --Bug 5069923
54: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
55: or ( (bhoi.organization_id in ( select posev.ORGANIZATION_ID_child
56: from PER_ORG_STRUCTURE_ELEMENTS posev
57: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
58: and exists ( select null
59: from hr_organization_information
60: where organization_id = posev.ORGANIZATION_ID_child
61: and org_information_context = 'CLASS'

Line 64: start with posev.ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))

60: where organization_id = posev.ORGANIZATION_ID_child
61: and org_information_context = 'CLASS'
62: and org_information1 = 'KR_BUSINESS_PLACE'
63: )
64: start with posev.ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))
65: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
66: )
67: )
68: or (bhoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

Line 68: or (bhoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

64: start with posev.ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')))
65: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
66: )
67: )
68: or (bhoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
69: )
70: )
71: )
72: and bhoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

Line 74: and ppa.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')

70: )
71: )
72: and bhoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
73: and choi.organization_id = to_number(bhoi.org_information10)
74: and ppa.business_group_id = pay_magtape_generic.get_parameter_value('BG_ID')
75: and ppa.report_type = 'YEA'
76: and ppa.report_qualifier = 'KR'
77: and ( (ppa.report_category in (g_normal_yea, g_interim_yea, g_re_yea)) or
78: (ppa.payroll_action_id = g_payroll_action_id) )

Line 83: and ((to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')) is null) or

79: and to_number(to_char(ppa.effective_date, 'YYYY')) = g_target_year
80: --
81: and ppa.action_type in ('B','X')
82: and paa.payroll_action_id = ppa.payroll_action_id
83: and ((to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')) is null) or
84: (hr_assignment_set.assignment_in_set(to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')),
85: paa.assignment_id) = 'Y'))
86: and (('X' <> 'R') or
87: (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, g_payroll_action_id, g_target_year) = 'Y')) -- Bug 4726974

Line 84: (hr_assignment_set.assignment_in_set(to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')),

80: --
81: and ppa.action_type in ('B','X')
82: and paa.payroll_action_id = ppa.payroll_action_id
83: and ((to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')) is null) or
84: (hr_assignment_set.assignment_in_set(to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')),
85: paa.assignment_id) = 'Y'))
86: and (('X' <> 'R') or
87: (pay_kr_yea_magtape_fun_pkg.latest_yea_action(paa.assignment_action_id, g_payroll_action_id, g_target_year) = 'Y')) -- Bug 4726974
88: and paa.tax_unit_id = bhoi.organization_id

Line 142: pae.assignment_id =pay_magtape_generic.get_parameter_value('ASSIGN_ID')

138: aei_information8 resident_reg_no,
139: aei_information9 disabled_or_aged
140: from PER_ASSIGNMENT_EXTRA_INFO pae
141: where
142: pae.assignment_id =pay_magtape_generic.get_parameter_value('ASSIGN_ID')
143: and pae.information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
144: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year
145: group by pae.assignment_id, aei_information8,aei_information5,aei_information6,aei_information13,
146: aei_information7,aei_information8 ,aei_information9