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

Line 43: ,ARGUMENT1 => 'pay_magtape_generic.new_formula'

39: l_req_id := fnd_request.submit_request (
40: APPLICATION => 'PAY'
41: ,PROGRAM => 'PAYKRSEF_NS_B'
42: ,DESCRIPTION => 'KR Separation Pay E-File (MAGTAPE)'
43: ,ARGUMENT1 => 'pay_magtape_generic.new_formula'
44: ,ARGUMENT2 => p_magnetic_file_name
45: ,ARGUMENT3 => p_report_file_name
46: ,ARGUMENT4 => p_effective_date
47: ,ARGUMENT5 => 'MAGTAPE_REPORT_ID=KR_NS_SPAY_EFILE'

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

90: and hoi.org_information10 = phoi.org_information10
91: and phou.organization_id = primary_business_place_id
92: and phou.organization_id = phoi.organization_id
93: --Bug 5069923
94: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
95: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child
96: from PER_ORG_STRUCTURE_ELEMENTS posev
97: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
98: and exists ( select null

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

93: --Bug 5069923
94: and ( (pay_magtape_generic.get_parameter_value('REPORT_FOR')='A')
95: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child
96: from PER_ORG_STRUCTURE_ELEMENTS posev
97: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
98: and exists ( select null
99: from hr_organization_information
100: where organization_id = posev.ORGANIZATION_ID_child
101: and org_information_context = 'CLASS'

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

100: where organization_id = posev.ORGANIZATION_ID_child
101: and org_information_context = 'CLASS'
102: and org_information1 = 'KR_BUSINESS_PLACE'
103: )
104: start with ORGANIZATION_ID_PARENT = (decode(pay_magtape_generic.get_parameter_value('REPORT_FOR'),'S',null,'SUB',primary_business_place_id))
105: connect by prior ORGANIZATION_ID_child = ORGANIZATION_ID_PARENT
106: )
107: )
108: or (hoi.organization_id = primary_business_place_id

Line 123: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)

119: ,pay_payroll_actions xppa
120: where xppa.action_type = 'X'
121: and xppa.action_status = 'C'
122: --Bug 5069923
123: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
124: and xppa.effective_date between
125: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
126: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
127: and xppa.payroll_action_id = xpaa.payroll_action_id

Line 125: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')

121: and xppa.action_status = 'C'
122: --Bug 5069923
123: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
124: and xppa.effective_date between
125: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
126: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
127: and xppa.payroll_action_id = xpaa.payroll_action_id
128: and xpaa.action_status = 'C'
129: --Bug 5069923

Line 126: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')

122: --Bug 5069923
123: and xppa.payroll_action_id = nvl(pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID'),xpaa.payroll_action_id)
124: and xppa.effective_date between
125: to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'0101','YYYYMMDD')
126: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
127: and xppa.payroll_action_id = xpaa.payroll_action_id
128: and xpaa.action_status = 'C'
129: --Bug 5069923
130: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

Line 130: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)

126: and to_date(pay_magtape_generic.get_parameter_value('TARGET_YEAR')||'1231','YYYYMMDD')
127: and xppa.payroll_action_id = xpaa.payroll_action_id
128: and xpaa.action_status = 'C'
129: --Bug 5069923
130: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
131: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
132: )
133: and xppa.report_type = 'KR_SEP'
134: --Bug 5069923

Line 131: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')

127: and xppa.payroll_action_id = xpaa.payroll_action_id
128: and xpaa.action_status = 'C'
129: --Bug 5069923
130: and ( (pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID') is null)
131: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
132: )
133: and xppa.report_type = 'KR_SEP'
134: --Bug 5069923
135: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

Line 135: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

131: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
132: )
133: and xppa.report_type = 'KR_SEP'
134: --Bug 5069923
135: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
136: and xpaa.tax_unit_id = hou.organization_id
137: and fue.user_entity_name in ('A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN','A_RECEIVABLE_NON_STAT_SEP_PAY_ASG_RUN','A_RECEIVABLE_SEPARATION_PAY_ASG_RUN',
138: 'A_TAXABLE_EARNINGS_WI_PREV_ASG_RUN' ) --Bug 9409509
139: and fue.legislation_code = 'KR'

Line 187: g_bp_count := get_bp_count(pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID'));

183: end;
184:
185: begin
186:
187: g_bp_count := get_bp_count(pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID'));
188:
189: end pay_kr_nonstat_spay_efile;