DBA Data[Home] [Help]

APPS.PAY_IN_INDIA_BENEFITS dependencies on PER_PEOPLE_F

Line 1724: ,per_people_f person

1720: IS
1721: SELECT NVL(DECODE(p_ltc_or_med,'LTC',org_information1,'MED',org_information2),'N') lock_flag
1722: FROM
1723: hr_organization_information org
1724: ,per_people_f person
1725: WHERE
1726: org.org_information_context = 'PER_IN_BENEFITS_DECL_INFO'
1727: AND org.organization_id = person.business_group_id
1728: AND person.person_id = p_person_id