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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

79: --
80: and ppa.action_type = 'X'
81: and paa.payroll_action_id = ppa.payroll_action_id
82: and (
83: (to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')) is null)
84: or
85: (hr_assignment_set.assignment_in_set(
86: to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')), paa.assignment_id)
87: = 'Y')

Line 86: to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')), paa.assignment_id)

82: and (
83: (to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')) is null)
84: or
85: (hr_assignment_set.assignment_in_set(
86: to_number(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID')), paa.assignment_id)
87: = 'Y')
88: )
89: and (
90: (g_re_yea <> 'R')

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

124: nvl(aei_information11, ' ') receipt_number /* Bug 6764369 */
125: from
126: per_assignment_extra_info pae
127: where
128: pae.assignment_id = pay_magtape_generic.get_parameter_value('ASSIGN_ID')
129: and pae.information_type = 'KR_YEA_DETAIL_DONATION_INFO'
130: and to_char(fnd_date.canonical_to_date(pae.aei_information1),'yyyy')
131: = g_target_year
132: group by