DBA Data[Home] [Help]

APPS.PAY_CN_DEDUCTIONS dependencies on HR_SOFT_CODING_KEYFLEX

Line 99: -- G_KEYFLEX_KFV to HR_SOFT_CODING_KEYFLEX --

95: -- 1.0 18-FEB-03 vinaraya Created this function --
96: -- 1.1 19-MAR-03 vinaraya Changed the indentation --
97: -- 1.2 20-MAR-03 vinaraya Changed the tables PER_ALL_ASSIGNMENTS_F --
98: -- to PER_ALL_ASSIGNMENTS and HR_SOFT_CODIN --
99: -- G_KEYFLEX_KFV to HR_SOFT_CODING_KEYFLEX --
100: -- in csr_tax for performance reasons. --
101: -- 1.3 20-MAR-03 vinaraya Changed the p_special_payment_type_id --
102: -- to l_special_payment_type_id in the --
103: -- csr_tax cursor definition. --

Line 134: ,hr_soft_coding_keyflex hsc

130: ) IS
131: SELECT hoi.org_information3
132: FROM hr_organization_information hoi
133: ,per_all_assignments paf
134: ,hr_soft_coding_keyflex hsc
135: ,hr_all_organization_units hou
136: WHERE paf.assignment_id = p_assignment_id
137: AND paf.soft_coding_keyflex_id = hsc.soft_coding_keyflex_id
138: AND hsc.segment1 = hou.organization_id