DBA Data[Home] [Help]

APPS.PAY_GET_JOB_SEGMENT_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 61: ,fnd_id_flex_structures str

57: ,(select seg.APPLICATION_COLUMN_NAME
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'

Line 82: ,fnd_id_flex_structures str

78: --
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'

Line 134: ,fnd_id_flex_structures str

130: --
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'