DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on PER_PEOPLE_F

Line 1781: ,per_people_f person

1777: IS
1778: SELECT NVL(DECODE(p_ltc_or_med,'LTC',org_information1,'MED',org_information2),'N') lock_flag
1779: FROM
1780: hr_organization_information org
1781: ,per_people_f person
1782: WHERE
1783: org.org_information_context = 'PER_IN_BENEFITS_DECL_INFO'
1784: AND org.organization_id = person.business_group_id
1785: AND person.person_id = p_person_id