DBA Data[Home] [Help]

APPS.PAY_NO_ABS_VALIDATION dependencies on HR_ORGANIZATION_INFORMATION

Line 91: ,hr_organization_information hoi

87: SELECT hoi.organization_id org_id
88: FROM per_all_assignments_f paaf
89: ,per_all_people_f papf
90: ,hr_soft_coding_keyflex hsc
91: ,hr_organization_information hoi
92: WHERE papf.person_id = c_person_id
93: AND paaf.person_id = papf.person_id
94: AND paaf.primary_flag = 'Y'
95: AND hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id

Line 107: FROM hr_organization_information

103: ,'YEARLY_DAYS' ,org_information2
104: ,'YEARLY_COUNT' ,org_information3
105: ,'EMPLOYER_PERIOD_DAYS' ,org_information4
106: ,0) override
107: FROM hr_organization_information
108: WHERE organization_id = c_org_id
109: AND org_information_context = 'NO_SC_OVERRIDE';
110: ----+
111: l_override csr_override_rule_values%ROWTYPE;