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.BEN_ELECTION_INFORMATION dependencies on PER_ALL_ASSIGNMENTS_F

Line 635: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

631: p_enrt_rt_id IN NUMBER,
632: p_entr_ann_val_flag IN VARCHAR2,
633: p_entr_val_at_enrt_flag IN VARCHAR2)
634: IS
635: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
636: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
637: l_organization_id per_all_assignments_f.organization_id%TYPE;
638: --GEVITY
639: l_dfnd_dummy NUMBER;

Line 636: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

632: p_entr_ann_val_flag IN VARCHAR2,
633: p_entr_val_at_enrt_flag IN VARCHAR2)
634: IS
635: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
636: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
637: l_organization_id per_all_assignments_f.organization_id%TYPE;
638: --GEVITY
639: l_dfnd_dummy NUMBER;
640: l_ann_dummy NUMBER;

Line 637: l_organization_id per_all_assignments_f.organization_id%TYPE;

633: p_entr_val_at_enrt_flag IN VARCHAR2)
634: IS
635: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
636: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
637: l_organization_id per_all_assignments_f.organization_id%TYPE;
638: --GEVITY
639: l_dfnd_dummy NUMBER;
640: l_ann_dummy NUMBER;
641: l_cmcd_dummy NUMBER;

Line 806: from per_all_assignments_f asg,

802: and prv.prtt_rt_val_stat_cd is null
803: and (prv.acty_base_rt_id = p_acty_base_rt_id
804: or exists
805: (select 'x'
806: from per_all_assignments_f asg,
807: pay_element_links_f pel,
808: pay_element_entries_f pee,
809: pay_element_entry_values_f pev
810: where pel.element_type_id = p_element_type_id

Line 1162: l_assignment_id per_all_assignments_f.assignment_id%type;

1158: l_ele_entry_val_cd varchar2(30);
1159: l_new_assignment_id number;
1160: l_new_payroll_id number;
1161: l_new_organization_id number;
1162: l_assignment_id per_all_assignments_f.assignment_id%type;
1163: l_payroll_id per_all_assignments_f.payroll_id%type;
1164: l_organization_id per_all_assignments_f.organization_id%type;
1165: l_ext_inpval_tab ben_element_entry.ext_inpval_tab_typ;
1166: l_inpval_tab ben_element_entry.inpval_tab_typ;

Line 1163: l_payroll_id per_all_assignments_f.payroll_id%type;

1159: l_new_assignment_id number;
1160: l_new_payroll_id number;
1161: l_new_organization_id number;
1162: l_assignment_id per_all_assignments_f.assignment_id%type;
1163: l_payroll_id per_all_assignments_f.payroll_id%type;
1164: l_organization_id per_all_assignments_f.organization_id%type;
1165: l_ext_inpval_tab ben_element_entry.ext_inpval_tab_typ;
1166: l_inpval_tab ben_element_entry.inpval_tab_typ;
1167: l_jurisdiction_code varchar2(30);

Line 1164: l_organization_id per_all_assignments_f.organization_id%type;

1160: l_new_payroll_id number;
1161: l_new_organization_id number;
1162: l_assignment_id per_all_assignments_f.assignment_id%type;
1163: l_payroll_id per_all_assignments_f.payroll_id%type;
1164: l_organization_id per_all_assignments_f.organization_id%type;
1165: l_ext_inpval_tab ben_element_entry.ext_inpval_tab_typ;
1166: l_inpval_tab ben_element_entry.inpval_tab_typ;
1167: l_jurisdiction_code varchar2(30);
1168: l_subpriority number;

Line 1404: per_all_assignments_f asg,

1400: pee.element_entry_id,
1401: -- pee.assignment_id,
1402: pee.effective_end_date
1403: from pay_element_links_f elk,
1404: per_all_assignments_f asg,
1405: pay_element_entries_f pee,
1406: pay_element_entry_values_f eev
1407: where eev.element_entry_value_id = p_element_entry_value_id
1408: and eev.element_entry_id = pee.element_entry_id

Line 1440: ,per_all_assignments_f asg

1436: CURSOR c_pay_period_strt_dt(p_effective_start_date date
1437: ) IS
1438: SELECT ptp.start_date -- 10058794
1439: FROM per_time_periods ptp
1440: ,per_all_assignments_f asg
1441: WHERE ptp.regular_payment_date >= p_effective_start_date -- 10058794
1442: and ptp.payroll_id = asg.payroll_id
1443: AND ptp.start_date <= p_effective_start_date
1444: AND p_business_group_id = asg.business_group_id

Line 1461: from per_all_assignments_f asg,

1457: cp_effective_date date,
1458: cp_orig_effective_date date
1459: ) is
1460: select pay.period_type
1461: from per_all_assignments_f asg,
1462: pay_payrolls_f pay,
1463: per_all_assignments_f asg2,
1464: pay_payrolls_f pay2
1465: where asg.person_id = cp_person_id

Line 1463: per_all_assignments_f asg2,

1459: ) is
1460: select pay.period_type
1461: from per_all_assignments_f asg,
1462: pay_payrolls_f pay,
1463: per_all_assignments_f asg2,
1464: pay_payrolls_f pay2
1465: where asg.person_id = cp_person_id
1466: and asg.assignment_type <> 'C'
1467: and asg.business_group_id = cp_business_group_id

Line 1496: from per_all_assignments_f asg,

1492: cp_effective_date date,
1493: cp_orig_effective_date date
1494: ) is
1495: select 1
1496: from per_all_assignments_f asg,
1497: per_all_assignments_f asg2
1498: where asg.person_id = cp_person_id
1499: and asg.assignment_type <> 'C'
1500: and asg.business_group_id = cp_business_group_id

Line 1497: per_all_assignments_f asg2

1493: cp_orig_effective_date date
1494: ) is
1495: select 1
1496: from per_all_assignments_f asg,
1497: per_all_assignments_f asg2
1498: where asg.person_id = cp_person_id
1499: and asg.assignment_type <> 'C'
1500: and asg.business_group_id = cp_business_group_id
1501: and asg.primary_flag = 'Y'

Line 4492: from per_all_assignments_f asg

4488:
4489: cursor c_asg is
4490: select asg.assignment_id ,
4491: asg.organization_id
4492: from per_all_assignments_f asg
4493: where asg.person_id = p_person_id
4494: and asg.assignment_type <> 'C'
4495: and asg.primary_flag = 'Y'
4496: and p_effective_date between

Line 4501: FROM hr_locations_all loc, per_all_assignments_f asg

4497: asg.effective_start_date and asg.effective_end_date;
4498:
4499: CURSOR c_state IS
4500: SELECT loc.region_2
4501: FROM hr_locations_all loc, per_all_assignments_f asg
4502: WHERE loc.location_id = asg.location_id
4503: AND asg.person_id = p_person_id
4504: and asg.assignment_type <> 'C'
4505: AND asg.primary_flag = 'Y'