APPS.PQH_RBC_RATE_RETRIEVAL dependencies on PER_ALL_PEOPLE_F

Line 13: g_per_rec per_all_people_f%ROWTYPE;

9: g_business_group_id number(15):= null;
10: g_criteria_rate_defn_id number(15):= null;
11: --
12: g_asg_rec per_all_assignments_f%ROWTYPE;
13: g_per_rec per_all_people_f%ROWTYPE;
14: g_empty_tab ff_exec.outputs_t; -- donot populate. Only to be used a default value
15: --
16: --
17: Type tc_criteria is record(

Line 1375: From per_all_people_f

1371: Where element_type_id = p_element_type_id;
1372: --
1373: Cursor csr_per_details (p_per_id in number)is
1374: Select *
1375: From per_all_people_f
1376: Where person_id = p_per_id
1377: and p_effective_date between effective_start_date and effective_end_date;
1378: --
1379: Cursor csr_asg_details (p_assignment_id in number) is

Line 1387: l_person_id per_all_people_f.person_id%type;

1383: and p_effective_date between effective_start_date and effective_end_date;
1384: --
1385: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1386: l_assignment_id per_all_assignments_f.assignment_id%type;
1387: l_person_id per_all_people_f.person_id%type;
1388: l_proc varchar2(72) := g_package||'determine_rbc_rate';
1389: --
1390: Begin
1391: --

Line 1505: From per_all_people_f

1501: Where element_type_id = p_element_type_id;
1502: --
1503: Cursor csr_per_details (p_per_id in number)is
1504: Select *
1505: From per_all_people_f
1506: Where person_id = p_per_id
1507: and p_effective_date between effective_start_date and effective_end_date;
1508: --
1509: Cursor csr_primary_asg_details is

Line 1525: l_person_id per_all_people_f.person_id%type;

1521: --
1522: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;
1523: l_criteria_list pqh_popl_criteria_ovrrd.g_crit_ovrrd_val_tbl;
1524: l_assignment_id per_all_assignments_f.assignment_id%type;
1525: l_person_id per_all_people_f.person_id%type;
1526: l_proc varchar2(72) := g_package||'determine_rbc_rate';
1527: --
1528: Begin
1529: --