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 567: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

563: p_enrt_rt_id IN NUMBER,
564: p_entr_ann_val_flag IN VARCHAR2,
565: p_entr_val_at_enrt_flag IN VARCHAR2)
566: IS
567: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
568: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
569: l_organization_id per_all_assignments_f.organization_id%TYPE;
570: --GEVITY
571: l_dfnd_dummy NUMBER;

Line 568: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

564: p_entr_ann_val_flag IN VARCHAR2,
565: p_entr_val_at_enrt_flag IN VARCHAR2)
566: IS
567: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
568: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
569: l_organization_id per_all_assignments_f.organization_id%TYPE;
570: --GEVITY
571: l_dfnd_dummy NUMBER;
572: l_ann_dummy NUMBER;

Line 569: l_organization_id per_all_assignments_f.organization_id%TYPE;

565: p_entr_val_at_enrt_flag IN VARCHAR2)
566: IS
567: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
568: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
569: l_organization_id per_all_assignments_f.organization_id%TYPE;
570: --GEVITY
571: l_dfnd_dummy NUMBER;
572: l_ann_dummy NUMBER;
573: l_cmcd_dummy NUMBER;

Line 721: from per_all_assignments_f asg,

717: and prv.prtt_rt_val_stat_cd is null
718: and (prv.acty_base_rt_id = p_acty_base_rt_id
719: or exists
720: (select 'x'
721: from per_all_assignments_f asg,
722: pay_element_links_f pel,
723: pay_element_entries_f pee,
724: pay_element_entry_values_f pev
725: where pel.element_type_id = p_element_type_id

Line 1016: l_assignment_id per_all_assignments_f.assignment_id%type;

1012: l_ele_entry_val_cd varchar2(30);
1013: l_new_assignment_id number;
1014: l_new_payroll_id number;
1015: l_new_organization_id number;
1016: l_assignment_id per_all_assignments_f.assignment_id%type;
1017: l_payroll_id per_all_assignments_f.payroll_id%type;
1018: l_organization_id per_all_assignments_f.organization_id%type;
1019: l_ext_inpval_tab ben_element_entry.ext_inpval_tab_typ;
1020: l_inpval_tab ben_element_entry.inpval_tab_typ;

Line 1017: l_payroll_id per_all_assignments_f.payroll_id%type;

1013: l_new_assignment_id number;
1014: l_new_payroll_id number;
1015: l_new_organization_id number;
1016: l_assignment_id per_all_assignments_f.assignment_id%type;
1017: l_payroll_id per_all_assignments_f.payroll_id%type;
1018: l_organization_id per_all_assignments_f.organization_id%type;
1019: l_ext_inpval_tab ben_element_entry.ext_inpval_tab_typ;
1020: l_inpval_tab ben_element_entry.inpval_tab_typ;
1021: l_jurisdiction_code varchar2(30);

Line 1018: l_organization_id per_all_assignments_f.organization_id%type;

1014: l_new_payroll_id number;
1015: l_new_organization_id number;
1016: l_assignment_id per_all_assignments_f.assignment_id%type;
1017: l_payroll_id per_all_assignments_f.payroll_id%type;
1018: l_organization_id per_all_assignments_f.organization_id%type;
1019: l_ext_inpval_tab ben_element_entry.ext_inpval_tab_typ;
1020: l_inpval_tab ben_element_entry.inpval_tab_typ;
1021: l_jurisdiction_code varchar2(30);
1022: l_subpriority number;

Line 1242: per_all_assignments_f asg,

1238: pee.element_entry_id,
1239: -- pee.assignment_id,
1240: pee.effective_end_date
1241: from pay_element_links_f elk,
1242: per_all_assignments_f asg,
1243: pay_element_entries_f pee,
1244: pay_element_entry_values_f eev
1245: where eev.element_entry_value_id = p_element_entry_value_id
1246: and eev.element_entry_id = pee.element_entry_id

Line 1279: from per_all_assignments_f asg,

1275: cp_effective_date date,
1276: cp_orig_effective_date date
1277: ) is
1278: select pay.period_type
1279: from per_all_assignments_f asg,
1280: pay_payrolls_f pay,
1281: per_all_assignments_f asg2,
1282: pay_payrolls_f pay2
1283: where asg.person_id = cp_person_id

Line 1281: per_all_assignments_f asg2,

1277: ) is
1278: select pay.period_type
1279: from per_all_assignments_f asg,
1280: pay_payrolls_f pay,
1281: per_all_assignments_f asg2,
1282: pay_payrolls_f pay2
1283: where asg.person_id = cp_person_id
1284: and asg.assignment_type <> 'C'
1285: and asg.business_group_id = cp_business_group_id

Line 3995: from per_all_assignments_f asg

3991:
3992: cursor c_asg is
3993: select asg.assignment_id ,
3994: asg.organization_id
3995: from per_all_assignments_f asg
3996: where asg.person_id = p_person_id
3997: and asg.assignment_type <> 'C'
3998: and asg.primary_flag = 'Y'
3999: and p_effective_date between

Line 4004: FROM hr_locations_all loc, per_all_assignments_f asg

4000: asg.effective_start_date and asg.effective_end_date;
4001:
4002: CURSOR c_state IS
4003: SELECT loc.region_2
4004: FROM hr_locations_all loc, per_all_assignments_f asg
4005: WHERE loc.location_id = asg.location_id
4006: AND asg.person_id = p_person_id
4007: and asg.assignment_type <> 'C'
4008: AND asg.primary_flag = 'Y'