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_DERIVE_PART_AND_RATE_FACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 587: per_all_assignments_f paf,

583: --
584: cursor c_paa is
585: select paa.assignment_action_id
586: from pay_assignment_actions paa,
587: per_all_assignments_f paf,
588: pay_payroll_actions ppa,
589: pay_action_classifications pac
590: where paf.person_id = p_person_id
591: and paa.assignment_id = paf.assignment_id

Line 711: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

707:
708: PROCEDURE run_rule(
709: p_formula_id IN NUMBER
710: --
711: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
712: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
713: ,p_pil_row IN ben_per_in_ler%ROWTYPE
714: --
715: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row

Line 712: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

708: PROCEDURE run_rule(
709: p_formula_id IN NUMBER
710: --
711: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
712: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
713: ,p_pil_row IN ben_per_in_ler%ROWTYPE
714: --
715: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
716: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 736: l_ass_rec per_all_assignments_f%ROWTYPE;

732: l_package VARCHAR2(80) := g_package || '.run_rule';
733: l_result NUMBER;
734: l_outputs ff_exec.outputs_t;
735: l_loc_rec hr_locations_all%ROWTYPE;
736: l_ass_rec per_all_assignments_f%ROWTYPE;
737: l_pl_rec ben_pl_f%ROWTYPE;
738: l_oipl_rec ben_oipl_f%ROWTYPE;
739: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
740: l_effective_date date ;

Line 952: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE

948: -- structures that the code requires.
949: --
950: PROCEDURE cache_data_structures(
951: p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
952: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
953: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
954: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
955: ,p_business_group_id IN NUMBER
956: ,p_effective_date IN DATE

Line 953: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE

949: --
950: PROCEDURE cache_data_structures(
951: p_comp_obj_tree_row IN OUT NOCOPY ben_manage_life_events.g_cache_proc_objects_rec
952: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
953: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
954: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
955: ,p_business_group_id IN NUMBER
956: ,p_effective_date IN DATE
957: ,p_person_id IN NUMBER

Line 1335: p_empasg_row IN per_all_assignments_f%ROWTYPE

1331: --
1332: END get_balance_date;
1333: --
1334: FUNCTION get_salary_date(
1335: p_empasg_row IN per_all_assignments_f%ROWTYPE
1336: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
1337: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
1338: ,p_person_id IN NUMBER
1339: ,p_effective_date IN DATE

Line 1336: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

1332: END get_balance_date;
1333: --
1334: FUNCTION get_salary_date(
1335: p_empasg_row IN per_all_assignments_f%ROWTYPE
1336: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
1337: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
1338: ,p_person_id IN NUMBER
1339: ,p_effective_date IN DATE
1340: ,p_min IN NUMBER

Line 1347: l_ass_rec per_all_assignments_f%ROWTYPE;

1343: RETURN DATE IS
1344: --
1345: l_package VARCHAR2(80) := g_package || '.get_salary_date';
1346: l_salary DATE;
1347: l_ass_rec per_all_assignments_f%ROWTYPE;
1348: -- New
1349: l_pay_annualization_factor number ;
1350: l_rate_flag varchar2(200) := 'N';
1351: l_not_found boolean := false;

Line 1365: from per_all_assignments_f asg,

1361: ppb.pay_annualization_factor,
1362: asg.normal_hours,
1363: asg.frequency,
1364: asg.assignment_id
1365: from per_all_assignments_f asg,
1366: per_pay_bases ppb
1367: where asg.assignment_type <> 'C'
1368: and asg.assignment_id = v_assignment_id
1369: and ppb.pay_basis_id = asg.pay_basis_id

Line 1398: FROM per_pay_proposals ppp, per_all_assignments_f paf

1394: -- Also added ppp.change_date <= p_effective_date to avoid getting the
1395: -- future dated salary rows.
1396: CURSOR c_gt_min IS
1397: SELECT MAX(ppp.change_date)
1398: FROM per_pay_proposals ppp, per_all_assignments_f paf
1399: WHERE paf.assignment_id = l_ass_rec.assignment_id
1400: and paf.assignment_type <> 'C'
1401: AND p_effective_date BETWEEN paf.effective_start_date
1402: AND paf.effective_end_date

Line 1411: FROM per_pay_proposals ppp, per_all_assignments_f paf

1407: AND ppp.change_date <= p_effective_date ;
1408: --
1409: CURSOR c_gt_max IS
1410: SELECT MAX(ppp.change_date)
1411: FROM per_pay_proposals ppp, per_all_assignments_f paf
1412: WHERE paf.assignment_id = l_ass_rec.assignment_id
1413: and paf.assignment_type <> 'C'
1414: AND p_effective_date BETWEEN paf.effective_start_date
1415: AND paf.effective_end_date

Line 1424: FROM per_pay_proposals ppp, per_all_assignments_f paf

1420: AND ppp.change_date <= p_effective_date;
1421: --
1422: CURSOR c_lt_max IS
1423: SELECT MAX(ppp.change_date)
1424: FROM per_pay_proposals ppp, per_all_assignments_f paf
1425: WHERE paf.assignment_id = l_ass_rec.assignment_id
1426: and paf.assignment_type <> 'C'
1427: AND p_effective_date BETWEEN paf.effective_start_date
1428: AND paf.effective_end_date

Line 1437: FROM per_pay_proposals ppp, per_all_assignments_f paf

1433: AND ppp.change_date <= p_effective_date;
1434: --
1435: CURSOR c_lt_min IS
1436: SELECT MAX(ppp.change_date)
1437: FROM per_pay_proposals ppp, per_all_assignments_f paf
1438: WHERE paf.assignment_id = l_ass_rec.assignment_id
1439: and paf.assignment_type <> 'C'
1440: AND p_effective_date BETWEEN paf.effective_start_date
1441: AND paf.effective_end_date

Line 1653: p_empasg_row IN per_all_assignments_f%ROWTYPE

1649: --
1650: END get_salary_date;
1651: --
1652: FUNCTION get_percent_date(
1653: p_empasg_row IN per_all_assignments_f%ROWTYPE
1654: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
1655: ,p_person_id IN NUMBER
1656: ,p_percent IN NUMBER
1657: ,p_effective_date IN DATE

Line 1654: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

1650: END get_salary_date;
1651: --
1652: FUNCTION get_percent_date(
1653: p_empasg_row IN per_all_assignments_f%ROWTYPE
1654: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
1655: ,p_person_id IN NUMBER
1656: ,p_percent IN NUMBER
1657: ,p_effective_date IN DATE
1658: ,p_min IN NUMBER

Line 1665: l_ass_rec per_all_assignments_f%ROWTYPE;

1661: RETURN DATE IS
1662: --
1663: l_package VARCHAR2(80) := g_package || '.get_percent_date';
1664: l_percent DATE;
1665: l_ass_rec per_all_assignments_f%ROWTYPE;
1666: --
1667: -- Assignment has been validated as primary already therefore no need
1668: -- to include join to per_assignments_f
1669: --

Line 1753: p_empasg_row IN per_all_assignments_f%ROWTYPE

1749: --
1750: END get_percent_date;
1751: --
1752: FUNCTION get_persons_salary(
1753: p_empasg_row IN per_all_assignments_f%ROWTYPE
1754: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
1755: ,p_person_id IN NUMBER
1756: ,p_business_group_id IN NUMBER
1757: ,p_effective_date IN DATE)

Line 1754: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

1750: END get_percent_date;
1751: --
1752: FUNCTION get_persons_salary(
1753: p_empasg_row IN per_all_assignments_f%ROWTYPE
1754: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
1755: ,p_person_id IN NUMBER
1756: ,p_business_group_id IN NUMBER
1757: ,p_effective_date IN DATE)
1758: RETURN NUMBER IS

Line 1762: l_ass_rec per_all_assignments_f%ROWTYPE;

1758: RETURN NUMBER IS
1759: --
1760: l_package VARCHAR2(80) := g_package || '.get_persons_salary';
1761: l_salary NUMBER(38);
1762: l_ass_rec per_all_assignments_f%ROWTYPE;
1763: --
1764: CURSOR c1 IS
1765: SELECT ppp.proposed_salary_n
1766: FROM per_pay_proposals ppp, per_all_assignments_f paf

Line 1766: FROM per_pay_proposals ppp, per_all_assignments_f paf

1762: l_ass_rec per_all_assignments_f%ROWTYPE;
1763: --
1764: CURSOR c1 IS
1765: SELECT ppp.proposed_salary_n
1766: FROM per_pay_proposals ppp, per_all_assignments_f paf
1767: WHERE paf.assignment_id = l_ass_rec.assignment_id
1768: and paf.assignment_type <> 'C'
1769: AND paf.business_group_id = p_business_group_id
1770: AND p_effective_date BETWEEN paf.effective_start_date

Line 2297: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

2293: END min_max_breach;
2294: --
2295: FUNCTION los_calculation(
2296: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2297: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2298: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2299: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2300: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2301: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 2298: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

2294: --
2295: FUNCTION los_calculation(
2296: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2297: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2298: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2299: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2300: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2301: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2302: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_los_rec_obj

Line 2326: l_ass_rec per_all_assignments_f%ROWTYPE;

2322: l_pps_rec per_periods_of_service%ROWTYPE;
2323: l_per_rec per_all_people_f%ROWTYPE;
2324: l_dummy_num NUMBER;
2325: l_aei_rec per_assignment_extra_info%ROWTYPE;
2326: l_ass_rec per_all_assignments_f%ROWTYPE;
2327: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2328: --
2329: BEGIN
2330: -- hr_utility.set_location('Entering ' || l_package,10);

Line 2584: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

2580: --
2581: FUNCTION age_calculation(
2582: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2583: ,p_per_row IN per_all_people_f%ROWTYPE
2584: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2585: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2586: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2587: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2588: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 2585: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

2581: FUNCTION age_calculation(
2582: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
2583: ,p_per_row IN per_all_people_f%ROWTYPE
2584: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
2585: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
2586: ,p_pil_row IN ben_per_in_ler%ROWTYPE
2587: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
2588: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
2589: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_age_rec_obj

Line 2617: l_ass_rec per_all_assignments_f%ROWTYPE;

2613: l_pil_rec ben_per_in_ler%ROWTYPE;
2614: l_pl_rec ben_pl_f%ROWTYPE;
2615: l_oipl_rec ben_oipl_f%ROWTYPE;
2616: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2617: l_ass_rec per_all_assignments_f%ROWTYPE;
2618: l_loc_rec hr_locations_all%ROWTYPE;
2619: l_per_rec per_all_people_f%ROWTYPE;
2620: l_person_id NUMBER;
2621: l_jurisdiction_code VARCHAR2(30);

Line 3032: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

3028: END age_calculation;
3029: --
3030: FUNCTION hours_calculation(
3031: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3032: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3033: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3034: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3035: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj
3036: ,p_business_group_id IN NUMBER

Line 3033: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

3029: --
3030: FUNCTION hours_calculation(
3031: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3032: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3033: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3034: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3035: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_hwf_rec_obj
3036: ,p_business_group_id IN NUMBER
3037: ,p_person_id IN NUMBER

Line 3057: l_ass_rec per_all_assignments_f%ROWTYPE;

3053: l_pl_rec ben_pl_f%ROWTYPE;
3054: l_oipl_rec ben_oipl_f%ROWTYPE;
3055: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3056: l_loc_rec hr_locations_all%ROWTYPE;
3057: l_ass_rec per_all_assignments_f%ROWTYPE;
3058: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
3059: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;
3060: l_jurisdiction_code VARCHAR2(30);
3061: l_assignment_action_id number;

Line 3066: From per_all_assignments_f ass

3062:
3063:
3064: Cursor c_ass is
3065: select min(effective_start_date)
3066: From per_all_assignments_f ass
3067: where person_id = p_person_id
3068: and ass.assignment_type <> 'C'
3069: and primary_flag = 'Y' ;
3070:

Line 3368: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

3364: -- different places.
3365: -------------------------------------------------------------------------------
3366: FUNCTION comp_calculation(
3367: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3368: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3369: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3370: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3371: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
3372: ,p_person_id IN NUMBER

Line 3369: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

3365: -------------------------------------------------------------------------------
3366: FUNCTION comp_calculation(
3367: p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3368: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3369: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3370: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3371: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
3372: ,p_person_id IN NUMBER
3373: ,p_business_group_id IN NUMBER

Line 3387: From per_all_assignments_f ass

3383:
3384: ---
3385: Cursor c_ass is
3386: select min(effective_start_date)
3387: From per_all_assignments_f ass
3388: where person_id = p_person_id
3389: and ass.assignment_type <> 'C'
3390: and primary_flag = 'Y' ;
3391:

Line 3404: l_ass_rec per_all_assignments_f%ROWTYPE;

3400: l_pl_rec ben_pl_f%ROWTYPE;
3401: l_oipl_rec ben_oipl_f%ROWTYPE;
3402: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
3403: l_loc_rec hr_locations_all%ROWTYPE;
3404: l_ass_rec per_all_assignments_f%ROWTYPE;
3405: l_bal_rec ben_per_bnfts_bal_f%ROWTYPE;
3406: l_bnb_rec ben_bnfts_bal_f%ROWTYPE;
3407: l_jurisdiction_code VARCHAR2(30);
3408: l_assignment_action_id number;

Line 3769: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

3765: --
3766: PROCEDURE calculate_los
3767: (p_calculate_only_mode in boolean default false
3768: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3769: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3770: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3771: ,p_pil_row IN ben_per_in_ler%ROWTYPE
3772: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
3773: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 3770: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

3766: PROCEDURE calculate_los
3767: (p_calculate_only_mode in boolean default false
3768: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
3769: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
3770: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
3771: ,p_pil_row IN ben_per_in_ler%ROWTYPE
3772: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
3773: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
3774: ,p_person_id IN NUMBER

Line 4497: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

4493: PROCEDURE calculate_age
4494: (p_calculate_only_mode in boolean default false
4495: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
4496: ,p_per_row IN per_all_people_f%ROWTYPE
4497: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
4498: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
4499: ,p_pil_row IN ben_per_in_ler%ROWTYPE
4500: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
4501: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 4498: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

4494: (p_calculate_only_mode in boolean default false
4495: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
4496: ,p_per_row IN per_all_people_f%ROWTYPE
4497: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
4498: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
4499: ,p_pil_row IN ben_per_in_ler%ROWTYPE
4500: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
4501: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
4502: ,p_person_id IN NUMBER

Line 5115: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

5111: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
5112: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5113: -- ,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5114: -- ,p_comp_rec IN OUT NOCOPY g_cache_structure
5115: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5116: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5117: ,p_person_id IN NUMBER
5118: ,p_pgm_id IN NUMBER
5119: ,p_pl_id IN NUMBER

Line 5116: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

5112: ,p_rec IN ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5113: -- ,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
5114: -- ,p_comp_rec IN OUT NOCOPY g_cache_structure
5115: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5116: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5117: ,p_person_id IN NUMBER
5118: ,p_pgm_id IN NUMBER
5119: ,p_pl_id IN NUMBER
5120: ,p_oipl_id IN NUMBER

Line 5453: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

5449: --
5450: PROCEDURE calculate_compensation_level
5451: (p_calculate_only_mode in boolean default false
5452: ,p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
5453: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5454: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5455: ,p_pil_row IN ben_per_in_ler%ROWTYPE
5456: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
5457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 5454: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

5450: PROCEDURE calculate_compensation_level
5451: (p_calculate_only_mode in boolean default false
5452: ,p_comp_obj_tree_row in ben_manage_life_events.g_cache_proc_objects_rec
5453: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
5454: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
5455: ,p_pil_row IN ben_per_in_ler%ROWTYPE
5456: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
5457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
5458: ,p_person_id IN NUMBER

Line 6758: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

6754: PROCEDURE calculate_comb_age_and_los
6755: (p_calculate_only_mode in boolean default false
6756: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
6757: ,p_per_row IN per_all_people_f%ROWTYPE
6758: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
6759: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
6760: ,p_pil_row IN ben_per_in_ler%ROWTYPE
6761: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
6762: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 6759: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

6755: (p_calculate_only_mode in boolean default false
6756: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
6757: ,p_per_row IN per_all_people_f%ROWTYPE
6758: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
6759: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
6760: ,p_pil_row IN ben_per_in_ler%ROWTYPE
6761: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
6762: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
6763: ,p_person_id IN NUMBER

Line 7460: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

7456: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
7457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
7458: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
7459: ,p_comp_rec IN OUT NOCOPY g_cache_structure
7460: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7461: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7462: ,p_person_id IN NUMBER
7463: ,p_pgm_id IN NUMBER
7464: ,p_pl_id IN NUMBER

Line 7461: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

7457: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
7458: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
7459: ,p_comp_rec IN OUT NOCOPY g_cache_structure
7460: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7461: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7462: ,p_person_id IN NUMBER
7463: ,p_pgm_id IN NUMBER
7464: ,p_pl_id IN NUMBER
7465: ,p_oipl_id IN NUMBER

Line 7594: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

7590:
7591: PROCEDURE calculate_percent_fulltime
7592: (p_calculate_only_mode in boolean default false
7593: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
7594: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7595: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7596: ,p_pil_row IN ben_per_in_ler%ROWTYPE
7597: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
7598: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 7595: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

7591: PROCEDURE calculate_percent_fulltime
7592: (p_calculate_only_mode in boolean default false
7593: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
7594: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
7595: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
7596: ,p_pil_row IN ben_per_in_ler%ROWTYPE
7597: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
7598: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
7599: ,p_person_id IN NUMBER

Line 7630: l_ass_rec per_all_assignments_f%ROWTYPE;

7626: l_rec ben_person_object.g_person_fte_info_rec;
7627: l_der_rec ben_seeddata_object.g_derived_factor_info_rec;
7628: l_der_cvg_rec ben_seeddata_object.g_derived_factor_info_rec;
7629: l_der_prem_rec ben_seeddata_object.g_derived_factor_info_rec;
7630: l_ass_rec per_all_assignments_f%ROWTYPE;
7631: l_rate BOOLEAN := FALSE;
7632: l_cvg BOOLEAN := FALSE;
7633: l_prem BOOLEAN := FALSE;
7634: --

Line 8187: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

8183: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
8184: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
8185: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
8186: ,p_comp_rec IN OUT NOCOPY g_cache_structure
8187: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8188: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8189: ,p_person_id IN NUMBER
8190: ,p_pgm_id IN NUMBER
8191: ,p_pl_id IN NUMBER

Line 8188: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

8184: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
8185: --,p_rate_rec IN OUT ben_derive_part_and_rate_cache.g_cache_clf_rec_obj
8186: ,p_comp_rec IN OUT NOCOPY g_cache_structure
8187: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8188: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8189: ,p_person_id IN NUMBER
8190: ,p_pgm_id IN NUMBER
8191: ,p_pl_id IN NUMBER
8192: ,p_oipl_id IN NUMBER

Line 8396: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

8392: --
8393: PROCEDURE calculate_hours_worked
8394: (p_calculate_only_mode in boolean default false
8395: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
8396: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8397: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8398: ,p_pil_row IN ben_per_in_ler%ROWTYPE
8399: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
8400: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row

Line 8397: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

8393: PROCEDURE calculate_hours_worked
8394: (p_calculate_only_mode in boolean default false
8395: ,p_comp_obj_tree_row IN ben_manage_life_events.g_cache_proc_objects_rec
8396: ,p_empasg_row IN per_all_assignments_f%ROWTYPE
8397: ,p_benasg_row IN per_all_assignments_f%ROWTYPE
8398: ,p_pil_row IN ben_per_in_ler%ROWTYPE
8399: ,p_curroipl_row IN ben_cobj_cache.g_oipl_inst_row
8400: ,p_curroiplip_row IN ben_cobj_cache.g_oiplip_inst_row
8401: ,p_person_id IN NUMBER

Line 9654: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

9650: l_amt_due number;
9651: l_late_pymt_evt BOOLEAN := FALSE;
9652: l_cobra_pymt_due_dy_num ben_pl_f.cobra_pymt_due_dy_num%TYPE;
9653: l_organization_id NUMBER;
9654: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
9655: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
9656: --
9657: CURSOR c_get_cbr_due_day(
9658: p_pl_id NUMBER) IS

Line 9655: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

9651: l_late_pymt_evt BOOLEAN := FALSE;
9652: l_cobra_pymt_due_dy_num ben_pl_f.cobra_pymt_due_dy_num%TYPE;
9653: l_organization_id NUMBER;
9654: l_assignment_id per_all_assignments_f.assignment_id%TYPE;
9655: l_payroll_id per_all_assignments_f.payroll_id%TYPE;
9656: --
9657: CURSOR c_get_cbr_due_day(
9658: p_pl_id NUMBER) IS
9659: SELECT pln.cobra_pymt_due_dy_num

Line 10717: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE

10713: --
10714: -- Context info
10715: --
10716: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE
10717: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10718: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10719: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
10720: --
10721: ,p_mode IN VARCHAR2 DEFAULT NULL

Line 10718: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE

10714: -- Context info
10715: --
10716: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE
10717: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10718: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10719: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
10720: --
10721: ,p_mode IN VARCHAR2 DEFAULT NULL
10722: --

Line 11175: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk

11171: l_tax_unit_id hr_soft_coding_keyflex.segment1%type ;
11172: --
11173: cursor c_tax is
11174: select cfk.segment1
11175: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk
11176: where asg.person_id = p_person_id
11177: and asg.assignment_type <> 'C'
11178: and asg.primary_flag = 'Y'
11179: AND p_effective_date BETWEEN asg.effective_start_date