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 41: ,ARGUMENT1 => 'pay_magtape_generic.new_formula'

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

128: or (hr_assignment_set.assignment_in_set(pay_magtape_generic.get_parameter_value('ASSIGNMENT_SET_ID'), xpaa.assignment_id) = 'Y')
129: )
130: and xppa.report_type = 'KR_SEP'
131: --Bug 5069923
132: and xppa.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')
133: and xpaa.tax_unit_id = hou.organization_id
134: and fue.user_entity_name = 'A_NON_STAT_SEP_PAY_TAXABLE_EARNINGS_ASG_RUN'
135: and fue.legislation_code = 'KR'
136: and fai.user_entity_id = fue.user_entity_id

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

147: end get_bp_count;
148:
149: begin
150:
151: g_bp_count := get_bp_count(pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID'));
152:
153: end pay_kr_nonstat_spay_efile;