APPS.HXC_RPT_TC_AUDIT_TRAIL dependencies on PER_ALL_PEOPLE_F

Line 150: FROM per_all_people_f

146: IF (p_supervisor_id IS NOT NULL)
147: THEN
148: SELECT full_name
149: INTO lp_supervisor
150: FROM per_all_people_f
151: WHERE person_id = p_supervisor_id
152: AND SYSDATE BETWEEN effective_start_date
153: AND effective_END_date;
154:

Line 161: FROM per_all_people_f

157: IF (p_person_id IS NOT NULL)
158: THEN
159: SELECT full_name
160: INTO lp_person
161: FROM per_all_people_f
162: WHERE person_id = p_person_id
163: AND SYSDATE BETWEEN effective_start_date
164: AND effective_END_date;
165:

Line 173: FROM per_all_people_f ppf,

169:
170:
171: SELECT fnd.user_name||' ['||ppf.full_name||']'
172: INTO lp_user
173: FROM per_all_people_f ppf,
174: fnd_user fnd
175: WHERE ppf.person_id = fnd.employee_id
176: AND SYSDATE BETWEEN ppf.effective_start_date
177: AND ppf.effective_end_date

Line 662: FROM per_all_people_f

658:
659: CURSOR get_approvers ( p_person_id NUMBER,
660: p_appr_date DATE )
661: IS SELECT full_name
662: FROM per_all_people_f
663: WHERE person_id = p_person_id
664: AND p_appr_date BETWEEN effective_start_date
665: AND effective_end_date ;
666:

Line 687: -- To find out the user's name fetch the full name from PER_ALL_PEOPLE_F.

683: -- for all the APPLICATION_PERIOD records for this timecard.
684: -- The application periods are joined with BETWEEN & AND
685: -- conditions to pull up those timecards whose Approval period
686: -- spans across multiple timecard periods.
687: -- To find out the user's name fetch the full name from PER_ALL_PEOPLE_F.
688: -- To find out the transaction/submission that matches these approvals,
689: -- loops thru the transaction date pl/sql table already created, to find
690: -- a matching transaction.
691: -- Once all the transactions are picked up, inserts the records into HXC_RPT_TC_AUDIT.