DBA Data[Home] [Help]

APPS.PAY_IN_24Q_ER_RETURNS dependencies on PER_ALL_PEOPLE_F

Line 1085: FROM per_all_people_f

1081: CURSOR csr_person_category
1082: IS
1083: SELECT sex
1084: ,TO_CHAR(MONTHS_BETWEEN(SYSDATE, date_of_birth)) l_age
1085: FROM per_all_people_f
1086: WHERE person_id = p_person_id
1087: AND SYSDATE BETWEEN effective_start_date AND effective_end_date;
1088:
1089: l_procedure VARCHAR2(100);