DBA Data[Home] [Help]

APPS.PER_MEA_BUS dependencies on PER_BUSINESS_GROUPS

Line 1108: FROM per_business_groups pbg,

1104: -- Declare cursor
1105: --
1106: CURSOR csr_sec_grp is
1107: SELECT pbg.security_group_id
1108: FROM per_business_groups pbg,
1109: per_medical_assessments mea,
1110: per_people_f per
1111: WHERE mea.medical_assessment_id = p_medical_assessment_id
1112: AND per.person_id = mea.person_id

Line 1172: per_business_groups pbg

1168: cursor csr_leg_code is
1169: select pbg.legislation_code
1170: from per_medical_assessments mea,
1171: per_people_f per,
1172: per_business_groups pbg
1173: where mea.medical_assessment_id = p_medical_assessment_id
1174: and mea.person_id = per.person_id
1175: and per.business_group_id = pbg.business_group_id;
1176: --