DBA Data[Home] [Help]

APPS.PAY_MX_FF_UDFS dependencies on HR_ORGANIZATION_INFORMATION

Line 783: FROM hr_organization_information hoi

779:
780: BEGIN
781: SELECT put.user_table_name
782: INTO c_ws_tab_name
783: FROM hr_organization_information hoi
784: ,pay_user_tables put
785: WHERE hoi.organization_id = p_bg_id
786: AND hoi.org_information_context = 'Work Schedule'
787: AND hoi.org_information1 = put.user_table_id ;

Line 1137: hr_organization_information hoi

1133: cp_eff_date DATE )
1134: IS
1135: select hoi.org_information10
1136: from hr_organization_units hou,
1137: hr_organization_information hoi
1138: where hou.organization_id = cp_org_id
1139: and hoi.org_information_context ='MX_SOC_SEC_DETAILS'
1140: and hou.organization_id = hoi.organization_id
1141: and cp_eff_date between hou.date_from and nvl(hou.date_to,cp_eff_date) ;