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

Line 488: RETURN per_all_assignments_f.assignment_id%TYPE

484: FUNCTION primary_assignment_id (
485: p_person_id IN per_people_f.person_id%TYPE,
486: p_effective_date IN DATE
487: )
488: RETURN per_all_assignments_f.assignment_id%TYPE
489: IS
490: l_proc VARCHAR2 (72) ;
491:
492: CURSOR csr_prim_asg_id (

Line 515: l_prim_asg_id per_all_assignments_f.assignment_id%TYPE;

511: AND
512: past.assignment_status_type_id = paf.assignment_status_type_id AND
513: past.per_system_status = 'ACTIVE_ASSIGN';
514:
515: l_prim_asg_id per_all_assignments_f.assignment_id%TYPE;
516: BEGIN
517: g_debug :=hr_utility.debug_enabled;
518: if g_debug then
519: l_proc := g_package

Line 573: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

569: RETURN l_holiday_calendar_id;
570: END holiday_calendar_id;
571:
572: FUNCTION holiday_calendar_id (
573: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
574: p_effective_date IN DATE
575: )
576: RETURN hxt_holiday_calendars.id%TYPE
577: IS

Line 581: p_assignment_id per_all_assignments_f.assignment_id%TYPE,

577: IS
578: l_proc VARCHAR2 (72) ;
579:
580: CURSOR csr_holiday_calendar_id (
581: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
582: p_effective_date DATE
583: )
584: IS
585: SELECT hhc.id

Line 837: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

833: RETURN l_legislation_code;
834: END legislation_code;
835:
836: FUNCTION legislation_code (
837: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
838: p_effective_date IN DATE
839: )
840: RETURN per_business_groups.legislation_code%TYPE
841: IS

Line 845: p_asg_id per_all_assignments_f.assignment_id%TYPE,

841: IS
842: l_proc VARCHAR2 (72) ;
843:
844: CURSOR csr_business_group (
845: p_asg_id per_all_assignments_f.assignment_id%TYPE,
846: p_effective_date DATE
847: )
848: IS
849: SELECT paf.business_group_id

Line 879: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

875: RETURN l_legislation_code;
876: END legislation_code;
877:
878: FUNCTION assignment_is_active (
879: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
880: p_effective_date IN DATE
881: )
882: RETURN BOOLEAN
883: IS

Line 887: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

883: IS
884: l_proc VARCHAR2 (72) ;
885:
886: CURSOR csr_active_assignment (
887: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
888: p_effective_date DATE
889: )
890: IS
891: SELECT /*+ ORDERED

Line 951: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

947:
948: PROCEDURE inactive_emp_tcard (
949: p_batch_id IN NUMBER,
950: p_person_id IN hxt_timecards.for_person_id%TYPE,
951: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
952: p_period_id IN hxt_timecards.time_period_id%TYPE,
953: p_tim_id IN hxt_timecards.id%TYPE,
954: p_day IN DATE
955: )

Line 1213: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1209: END holiday_valid;
1210:
1211: FUNCTION element_link (
1212: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
1213: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1214: p_effective_date IN DATE
1215: )
1216: RETURN pay_element_links_f.element_link_id%TYPE
1217: IS

Line 1307: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1303: END element_link;
1304:
1305: FUNCTION element_linked (
1306: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
1307: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1308: p_effective_date IN DATE
1309: )
1310: RETURN BOOLEAN
1311: IS

Line 1359: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1355: FUNCTION valid_for_summing (
1356: p_element_id IN pay_element_types_f.element_type_id%TYPE,
1357: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
1358: p_day IN DATE,
1359: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1360: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1361: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1362: DEFAULT NULL,
1363: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1431: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1427:
1428: FUNCTION sum_valid_det_hours (
1429: p_tim_id IN hxt_timecards.id%TYPE,
1430: p_day IN DATE,
1431: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1432: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1433: )
1434: RETURN NUMBER
1435: IS

Line 1497: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1493:
1494: PROCEDURE day_over_24 (
1495: p_batch_id IN NUMBER,
1496: p_person_id IN hxt_timecards.for_person_id%TYPE,
1497: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1498: p_period_id IN hxt_timecards.time_period_id%TYPE,
1499: p_tim_id IN hxt_timecards.id%TYPE,
1500: p_day IN DATE,
1501: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

Line 1657: from per_all_assignments_f p1,

1653:
1654: CURSOR c_no_mid_period_change (p_person_id in number)
1655: is
1656: select 'Y'
1657: from per_all_assignments_f p1,
1658: hxt_timecards_x tim
1659: where tim.effective_start_date between p1.effective_start_date and p1.effective_end_date
1660: and tim.effective_end_date between p1.effective_start_date and p1.effective_end_date
1661: and p1.person_id = p_person_id