APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on HR_ORGANIZATION_INFORMATION

Line 71: FROM hr_organization_information hoi

67: ,'BP_COUNT=P'
68: , g_bp_count
69: ,'REPORTED_DATE=P'
70: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
71: FROM hr_organization_information hoi
72: ,hr_organization_information ihoi
73: ,hr_organization_information choi
74: ,hr_organization_units hou
75: ,hr_locations_all hla

Line 72: ,hr_organization_information ihoi

68: , g_bp_count
69: ,'REPORTED_DATE=P'
70: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
71: FROM hr_organization_information hoi
72: ,hr_organization_information ihoi
73: ,hr_organization_information choi
74: ,hr_organization_units hou
75: ,hr_locations_all hla
76: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

Line 73: ,hr_organization_information choi

69: ,'REPORTED_DATE=P'
70: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
71: FROM hr_organization_information hoi
72: ,hr_organization_information ihoi
73: ,hr_organization_information choi
74: ,hr_organization_units hou
75: ,hr_locations_all hla
76: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
77: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

Line 110: FROM hr_organization_information hoi

106: 'CORP_REP_NAME=P',
107: choi.org_information6,
108: 'CORP_REG_NUMBER=P',
109: choi.org_information2
110: FROM hr_organization_information hoi
111: ,hr_organization_information ihoi
112: ,hr_organization_information choi
113: WHERE hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
114: and hoi.organization_id = ihoi.organization_id

Line 111: ,hr_organization_information ihoi

107: choi.org_information6,
108: 'CORP_REG_NUMBER=P',
109: choi.org_information2
110: FROM hr_organization_information hoi
111: ,hr_organization_information ihoi
112: ,hr_organization_information choi
113: WHERE hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
114: and hoi.organization_id = ihoi.organization_id
115: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'

Line 112: ,hr_organization_information choi

108: 'CORP_REG_NUMBER=P',
109: choi.org_information2
110: FROM hr_organization_information hoi
111: ,hr_organization_information ihoi
112: ,hr_organization_information choi
113: WHERE hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
114: and hoi.organization_id = ihoi.organization_id
115: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
116: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')

Line 127: from hr_organization_information

123: from PER_ORG_STRUCTURE_ELEMENTS posev
124: where posev.org_structure_version_id = (pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
125: and exists (
126: select null
127: from hr_organization_information
128: where organization_id = posev.ORGANIZATION_ID_child
129: and org_information_context = 'CLASS'
130: and org_information1 = 'KR_BUSINESS_PLACE'
131: )

Line 257: ,hr_organization_information hoi

253: ,'REPORTING_PERIOD=P'
254: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')
255: FROM pay_assignment_actions xpaa
256: ,pay_payroll_actions xppa
257: ,hr_organization_information hoi
258: ,hr_organization_information ihoi
259: ,hr_organization_units hou
260: ,ff_user_entities fue
261: ,ff_archive_items fai

Line 258: ,hr_organization_information ihoi

254: ,pay_magtape_generic.get_parameter_value('REPORTING_PERIOD')
255: FROM pay_assignment_actions xpaa
256: ,pay_payroll_actions xppa
257: ,hr_organization_information hoi
258: ,hr_organization_information ihoi
259: ,hr_organization_units hou
260: ,ff_user_entities fue
261: ,ff_archive_items fai
262: ,ff_user_entities fue1

Line 400: ,hr_organization_information hoi

396:
397:
398: FROM pay_assignment_actions xpaa
399: ,pay_payroll_actions xppa
400: ,hr_organization_information hoi
401: ,hr_organization_units hou
402: ,ff_user_entities fue
403: ,ff_archive_items fai
404: ,ff_user_entities fue1