DBA Data[Home] [Help]

APPS.PAY_MX_FF_UDFS dependencies on HR_ORGANIZATION_INFORMATION

Line 770: FROM hr_organization_information hoi

766:
767: BEGIN
768: SELECT put.user_table_name
769: INTO c_ws_tab_name
770: FROM hr_organization_information hoi
771: ,pay_user_tables put
772: WHERE hoi.organization_id = p_bg_id
773: AND hoi.org_information_context = 'Work Schedule'
774: AND hoi.org_information1 = put.user_table_id ;

Line 985: hr_organization_information hoi

981: cp_eff_date DATE )
982: IS
983: select hoi.org_information10
984: from hr_organization_units hou,
985: hr_organization_information hoi
986: where hou.organization_id = cp_org_id
987: and hoi.org_information_context ='MX_SOC_SEC_DETAILS'
988: and hou.organization_id = hoi.organization_id
989: and cp_eff_date between hou.date_from and nvl(hou.date_to,cp_eff_date) ;