APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on HR_ORGANIZATION_INFORMATION

Line 65: FROM hr_organization_information hoi

61: ,'BP_COUNT=P'
62: , g_bp_count
63: ,'REPORTED_DATE=P'
64: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
65: FROM hr_organization_information hoi
66: ,hr_organization_information ihoi
67: ,hr_organization_information choi
68: ,hr_organization_units hou
69: ,hr_locations_all hla

Line 66: ,hr_organization_information ihoi

62: , g_bp_count
63: ,'REPORTED_DATE=P'
64: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
65: FROM hr_organization_information hoi
66: ,hr_organization_information ihoi
67: ,hr_organization_information choi
68: ,hr_organization_units hou
69: ,hr_locations_all hla
70: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

Line 67: ,hr_organization_information choi

63: ,'REPORTED_DATE=P'
64: ,pay_magtape_generic.get_parameter_value('REPORTED_DATE')
65: FROM hr_organization_information hoi
66: ,hr_organization_information ihoi
67: ,hr_organization_information choi
68: ,hr_organization_units hou
69: ,hr_locations_all hla
70: WHERE hou.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
71: and hou.business_group_id = pay_magtape_generic.get_parameter_value('BUSINESS_GROUP_ID')

Line 104: FROM hr_organization_information hoi

100: 'CORP_REP_NAME=P',
101: choi.org_information6,
102: 'CORP_REG_NUMBER=P',
103: choi.org_information2
104: FROM hr_organization_information hoi
105: ,hr_organization_information ihoi
106: ,hr_organization_information choi
107: WHERE hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
108: and hoi.organization_id = ihoi.organization_id

Line 105: ,hr_organization_information ihoi

101: choi.org_information6,
102: 'CORP_REG_NUMBER=P',
103: choi.org_information2
104: FROM hr_organization_information hoi
105: ,hr_organization_information ihoi
106: ,hr_organization_information choi
107: WHERE hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
108: and hoi.organization_id = ihoi.organization_id
109: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'

Line 106: ,hr_organization_information choi

102: 'CORP_REG_NUMBER=P',
103: choi.org_information2
104: FROM hr_organization_information hoi
105: ,hr_organization_information ihoi
106: ,hr_organization_information choi
107: WHERE hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
108: and hoi.organization_id = ihoi.organization_id
109: and ihoi.org_information_context = 'KR_INCOME_TAX_OFFICE'
110: and hoi.org_information10 = pay_magtape_generic.get_parameter_value('CORPORATION_ID')

Line 121: from hr_organization_information

117: from PER_ORG_STRUCTURE_ELEMENTS posev
118: where posev.org_structure_version_id = (pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
119: and exists (
120: select null
121: from hr_organization_information
122: where organization_id = posev.ORGANIZATION_ID_child
123: and org_information_context = 'CLASS'
124: and org_information1 = 'KR_BUSINESS_PLACE'
125: )

Line 196: ,hr_organization_information hoi

192: ,'PREV_EMP_COUNT=P'
193: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
194: FROM pay_assignment_actions xpaa
195: ,pay_payroll_actions xppa
196: ,hr_organization_information hoi
197: ,hr_organization_information ihoi
198: ,hr_organization_units hou
199: ,ff_user_entities fue
200: ,ff_archive_items fai

Line 197: ,hr_organization_information ihoi

193: ,SUM(decode(fue.user_entity_name ,'X_KR_PREV_BP_NUMBER',1,0)) PREVEMPCOUNT
194: FROM pay_assignment_actions xpaa
195: ,pay_payroll_actions xppa
196: ,hr_organization_information hoi
197: ,hr_organization_information ihoi
198: ,hr_organization_units hou
199: ,ff_user_entities fue
200: ,ff_archive_items fai
201: ,ff_user_entities fue1

Line 282: ,hr_organization_information hoi

278: ,'PREVIOUS_EMP_COUNT=P'
279: ,pay_kr_nonstat_spay_efile_fun.get_prev_emp_count(xpaa.assignment_action_id)
280: FROM pay_assignment_actions xpaa
281: ,pay_payroll_actions xppa
282: ,hr_organization_information hoi
283: ,hr_organization_units hou
284: ,ff_user_entities fue
285: ,ff_archive_items fai
286: ,ff_user_entities fue1