DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PER_ALL_PEOPLE_F

Line 1031: FROM per_all_people_f

1027: CURSOR csr_person_category
1028: IS
1029: SELECT sex
1030: ,TO_CHAR(MONTHS_BETWEEN(SYSDATE, date_of_birth)) l_age
1031: FROM per_all_people_f
1032: WHERE person_id = p_person_id
1033: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
1034:
1035: l_procedure VARCHAR2(100);