APPS.PAY_GET_JOB_SEGMENT_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 33: FUNCTION get_job_segment(p_organization_id in hr_organization_information.organization_id%type

29: -- Globals
30: --
31: g_package CONSTANT VARCHAR2(30) := 'PAY_GET_JOB_SEGMENT_PKG';
32: --
33: FUNCTION get_job_segment(p_organization_id in hr_organization_information.organization_id%type
34: ,p_job_definition_id in number
35: ,p_payroll_action_id in number)
36: return varchar2
37: IS

Line 56: from hr_organization_information tax

52:
53: --
54: cursor csr_col_name(l_tax_ref VARCHAR2) is
55: select upper(job.APPLICATION_COLUMN_NAME)
56: from hr_organization_information tax
57: ,(select seg.APPLICATION_COLUMN_NAME
58: ,bus.organization_id
59: ,seg.segment_name
60: from fnd_id_flex_segments seg

Line 62: ,hr_organization_information bus

58: ,bus.organization_id
59: ,seg.segment_name
60: from fnd_id_flex_segments seg
61: ,fnd_id_flex_structures str
62: ,hr_organization_information bus
63: where seg.id_flex_code = 'JOB'
64: and seg.application_id = 800
65: and seg.enabled_flag = 'Y'
66: and seg.display_flag = 'Y'

Line 83: ,hr_organization_information bus

79: cursor csr_enabled_segment_count is
80: select count(seg.segment_name)
81: from fnd_id_flex_segments seg
82: ,fnd_id_flex_structures str
83: ,hr_organization_information bus
84: where seg.id_flex_code = 'JOB'
85: and seg.application_id = 800
86: and seg.enabled_flag = 'Y'
87: and seg.display_flag = 'Y'

Line 135: ,hr_organization_information bus

131: CURSOR csr_single_seg is
132: select upper(seg.APPLICATION_COLUMN_NAME)
133: from fnd_id_flex_segments seg
134: ,fnd_id_flex_structures str
135: ,hr_organization_information bus
136: where seg.id_flex_code = 'JOB'
137: and seg.application_id = 800
138: and seg.enabled_flag = 'Y'
139: and seg.display_flag = 'Y'