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 42: bhoi_primary.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

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

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

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

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

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

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

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

Line 61: 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')))

57: where organization_id = posev.ORGANIZATION_ID_child
58: and org_information_context = 'CLASS'
59: and org_information1 = 'KR_BUSINESS_PLACE'
60: )
61: 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')))
62: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
63: )
64: )
65: or (bhoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

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

61: 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')))
62: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
63: )
64: )
65: or (bhoi.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
66: )
67: )
68: )
69: and bhoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

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

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

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

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

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

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

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

131: aei_information8 resident_reg_no,
132: aei_information9 disabled_or_aged
133: from PER_ASSIGNMENT_EXTRA_INFO pae
134: where
135: pae.assignment_id =pay_magtape_generic.get_parameter_value('ASSIGN_ID')
136: and pae.information_type = 'KR_YEA_DETAIL_MEDICAL_EXP_INFO'
137: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy') = g_target_year
138: group by pae.assignment_id, aei_information8,aei_information5,aei_information6,
139: aei_information7,aei_information8 ,aei_information9