eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_RBC_RATE_RETRIEVAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 12: g_asg_rec per_all_assignments_f%ROWTYPE;

8: g_element_type_id number(15):= null;
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: --

Line 70: l_organization_id per_all_assignments_f.organization_id%type;

66: l_outputs ff_exec.outputs_t;
67: j int;
68: l_param_tab_count number;
69: --
70: l_organization_id per_all_assignments_f.organization_id%type;
71: l_payroll_id per_all_assignments_f.payroll_id%type;
72: l_jurisdiction_code varchar2(150);
73: --
74: cursor csr_asg_details(p_asg_id in number) is

Line 71: l_payroll_id per_all_assignments_f.payroll_id%type;

67: j int;
68: l_param_tab_count number;
69: --
70: l_organization_id per_all_assignments_f.organization_id%type;
71: l_payroll_id per_all_assignments_f.payroll_id%type;
72: l_jurisdiction_code varchar2(150);
73: --
74: cursor csr_asg_details(p_asg_id in number) is
75: Select organization_id, payroll_id

Line 76: From per_all_assignments_f

72: l_jurisdiction_code varchar2(150);
73: --
74: cursor csr_asg_details(p_asg_id in number) is
75: Select organization_id, payroll_id
76: From per_all_assignments_f
77: Where assignment_id = p_asg_id
78: and p_effective_date between effective_start_date and effective_end_date;
79: begin
80: --

Line 633: l_organization_id per_all_assignments_f.organization_id%type;

629: l_outputs ff_exec.outputs_t;
630: j int;
631: l_param_tab_count number;
632: --
633: l_organization_id per_all_assignments_f.organization_id%type;
634: l_payroll_id per_all_assignments_f.payroll_id%type;
635: l_jurisdiction_code varchar2(150);
636: --
637: cursor csr_asg_details(p_asg_id in number) is

Line 634: l_payroll_id per_all_assignments_f.payroll_id%type;

630: j int;
631: l_param_tab_count number;
632: --
633: l_organization_id per_all_assignments_f.organization_id%type;
634: l_payroll_id per_all_assignments_f.payroll_id%type;
635: l_jurisdiction_code varchar2(150);
636: --
637: cursor csr_asg_details(p_asg_id in number) is
638: Select organization_id, payroll_id

Line 639: From per_all_assignments_f

635: l_jurisdiction_code varchar2(150);
636: --
637: cursor csr_asg_details(p_asg_id in number) is
638: Select organization_id, payroll_id
639: From per_all_assignments_f
640: Where assignment_id = p_asg_id
641: and p_effective_date between effective_start_date and effective_end_date;
642: begin
643: --

Line 1381: from per_all_assignments_f

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
1380: select *
1381: from per_all_assignments_f
1382: Where assignment_id = p_assignment_id
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;

Line 1386: l_assignment_id per_all_assignments_f.assignment_id%type;

1382: Where assignment_id = p_assignment_id
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

Line 1511: from per_all_assignments_f

1507: and p_effective_date between effective_start_date and effective_end_date;
1508: --
1509: Cursor csr_primary_asg_details is
1510: select *
1511: from per_all_assignments_f
1512: Where person_id = p_person_id
1513: and primary_flag = 'Y'
1514: and p_effective_date between effective_start_date and effective_end_date;
1515: --

Line 1518: from per_all_assignments_f

1514: and p_effective_date between effective_start_date and effective_end_date;
1515: --
1516: Cursor csr_asg_details is
1517: select *
1518: from per_all_assignments_f
1519: Where assignment_id = p_assignment_id
1520: and p_effective_date between effective_start_date and effective_end_date;
1521: --
1522: l_crit_rt_defn_id pqh_criteria_rate_defn.criteria_rate_defn_id%type;

Line 1524: l_assignment_id per_all_assignments_f.assignment_id%type;

1520: and p_effective_date between effective_start_date and effective_end_date;
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