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.

[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_FACTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 588: per_all_assignments_f paf,

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

Line 712: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 713: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 737: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 953: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE

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

Line 954: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE

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

Line 1336: p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 1337: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 1348: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 1366: from per_all_assignments_f asg,

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

Line 1399: FROM per_pay_proposals ppp, per_all_assignments_f paf

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

Line 1412: FROM per_pay_proposals ppp, per_all_assignments_f paf

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

Line 1425: FROM per_pay_proposals ppp, per_all_assignments_f paf

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

Line 1438: FROM per_pay_proposals ppp, per_all_assignments_f paf

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

Line 1654: p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 1655: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 1666: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 1754: p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 1755: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 1763: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 1767: FROM per_pay_proposals ppp, per_all_assignments_f paf

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

Line 2298: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 2299: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 2327: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 2585: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 2586: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 2618: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 3033: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 3034: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 3058: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 3067: From per_all_assignments_f ass

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

Line 3369: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 3370: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 3388: From per_all_assignments_f ass

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

Line 3405: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 3770: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 3771: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 4498: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 4499: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 5116: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 5117: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 5454: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 5455: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 6759: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 6760: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 7461: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 7462: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 7595: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 7596: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 7631: l_ass_rec per_all_assignments_f%ROWTYPE;

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

Line 8188: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 8189: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 8397: ,p_empasg_row IN per_all_assignments_f%ROWTYPE

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

Line 8398: ,p_benasg_row IN per_all_assignments_f%ROWTYPE

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

Line 9655: l_assignment_id per_all_assignments_f.assignment_id%TYPE;

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

Line 9656: l_payroll_id per_all_assignments_f.payroll_id%TYPE;

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

Line 10790: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE

10786: --
10787: -- Context info
10788: --
10789: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE
10790: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10791: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10792: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
10793: --
10794: ,p_mode IN VARCHAR2 DEFAULT NULL

Line 10791: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE

10787: -- Context info
10788: --
10789: ,p_per_row IN OUT NOCOPY per_all_people_f%ROWTYPE
10790: ,p_empasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10791: ,p_benasg_row IN OUT NOCOPY per_all_assignments_f%ROWTYPE
10792: ,p_pil_row IN OUT NOCOPY ben_per_in_ler%ROWTYPE
10793: --
10794: ,p_mode IN VARCHAR2 DEFAULT NULL
10795: --

Line 11248: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk

11244: l_tax_unit_id hr_soft_coding_keyflex.segment1%type ;
11245: --
11246: cursor c_tax is
11247: select cfk.segment1
11248: from per_all_assignments_f asg, hr_soft_coding_keyflex cfk
11249: where asg.person_id = p_person_id
11250: and asg.assignment_type <> 'C'
11251: and asg.primary_flag = 'Y'
11252: AND p_effective_date BETWEEN asg.effective_start_date