DBA Data[Home] [Help]

APPS.PER_PMS_BUS dependencies on PER_ALL_ASSIGNMENTS_F

Line 32: , per_all_assignments_f paf

28: cursor csr_sec_grp is
29: select pbg.security_group_id,
30: pbg.legislation_code
31: from per_business_groups_perf pbg
32: , per_all_assignments_f paf
33: , per_personal_scorecards pms
34: where pms.scorecard_id = p_scorecard_id
35: and pms.assignment_id = paf.assignment_id
36: and paf.business_group_id = pbg.business_group_id;

Line 105: , per_all_assignments_f paf

101: --
102: cursor csr_leg_code is
103: select pbg.legislation_code
104: from per_business_groups_perf pbg
105: , per_all_assignments_f paf
106: , per_personal_scorecards pms
107: where pms.scorecard_id = p_scorecard_id
108: and pms.assignment_id = paf.assignment_id
109: and paf.business_group_id = pbg.business_group_id;

Line 467: FROM per_all_assignments_f asg

463: --
464:
465: CURSOR csr_chk_assignment_id IS
466: SELECT asg.assignment_id, asg.person_id
467: FROM per_all_assignments_f asg
468: WHERE asg.assignment_id = p_assignment_id
469: AND asg.assignment_type <> 'B';
470: --
471: BEGIN