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 550: RETURN per_all_assignments_f.assignment_id%TYPE

546: FUNCTION primary_assignment_id (
547: p_person_id IN per_people_f.person_id%TYPE,
548: p_effective_date IN DATE
549: )
550: RETURN per_all_assignments_f.assignment_id%TYPE
551: IS
552: l_proc VARCHAR2 (72) ;
553:
554: CURSOR csr_prim_asg_id (

Line 577: l_prim_asg_id per_all_assignments_f.assignment_id%TYPE;

573: AND
574: past.assignment_status_type_id = paf.assignment_status_type_id AND
575: past.per_system_status = 'ACTIVE_ASSIGN';
576:
577: l_prim_asg_id per_all_assignments_f.assignment_id%TYPE;
578: BEGIN
579: g_debug :=hr_utility.debug_enabled;
580: if g_debug then
581: l_proc := g_package

Line 635: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

631: RETURN l_holiday_calendar_id;
632: END holiday_calendar_id;
633:
634: FUNCTION holiday_calendar_id (
635: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
636: p_effective_date IN DATE
637: )
638: RETURN hxt_holiday_calendars.id%TYPE
639: IS

Line 643: p_assignment_id per_all_assignments_f.assignment_id%TYPE,

639: IS
640: l_proc VARCHAR2 (72) ;
641:
642: CURSOR csr_holiday_calendar_id (
643: p_assignment_id per_all_assignments_f.assignment_id%TYPE,
644: p_effective_date DATE
645: )
646: IS
647: SELECT hhc.id

Line 928: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

924: RETURN l_legislation_code;
925: END legislation_code;
926:
927: FUNCTION legislation_code (
928: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
929: p_effective_date IN DATE
930: )
931: RETURN per_business_groups.legislation_code%TYPE
932: IS

Line 936: p_asg_id per_all_assignments_f.assignment_id%TYPE,

932: IS
933: l_proc VARCHAR2 (72) ;
934:
935: CURSOR csr_business_group (
936: p_asg_id per_all_assignments_f.assignment_id%TYPE,
937: p_effective_date DATE
938: )
939: IS
940: SELECT paf.business_group_id

Line 970: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

966: RETURN l_legislation_code;
967: END legislation_code;
968:
969: FUNCTION assignment_is_active (
970: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
971: p_effective_date IN DATE
972: )
973: RETURN BOOLEAN
974: IS

Line 978: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,

974: IS
975: l_proc VARCHAR2 (72) ;
976:
977: CURSOR csr_active_assignment (
978: p_asg_id IN per_all_assignments_f.assignment_id%TYPE,
979: p_effective_date DATE
980: )
981: IS
982: SELECT /*+ ORDERED

Line 1042: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1038:
1039: PROCEDURE inactive_emp_tcard (
1040: p_batch_id IN NUMBER,
1041: p_person_id IN hxt_timecards.for_person_id%TYPE,
1042: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1043: p_period_id IN hxt_timecards.time_period_id%TYPE,
1044: p_tim_id IN hxt_timecards.id%TYPE,
1045: p_day IN DATE
1046: )

Line 1393: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1389: END holiday_valid;
1390:
1391: FUNCTION element_link (
1392: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
1393: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1394: p_effective_date IN DATE
1395: )
1396: RETURN pay_element_links_f.element_link_id%TYPE
1397: IS

Line 1487: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1483: END element_link;
1484:
1485: FUNCTION element_linked (
1486: p_element_type_id IN pay_element_types_f.element_type_id%TYPE,
1487: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1488: p_effective_date IN DATE
1489: )
1490: RETURN BOOLEAN
1491: IS

Line 1539: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1535: FUNCTION valid_for_summing (
1536: p_element_id IN pay_element_types_f.element_type_id%TYPE,
1537: p_earnings_category IN hxt_add_elem_info_f.earning_category%TYPE,
1538: p_day IN DATE,
1539: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1540: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE,
1541: p_valid_earn_cat1 IN hxt_add_elem_info_f.earning_category%TYPE
1542: DEFAULT NULL,
1543: p_valid_earn_cat2 IN hxt_add_elem_info_f.earning_category%TYPE

Line 1611: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1607:
1608: FUNCTION sum_valid_det_hours (
1609: p_tim_id IN hxt_timecards.id%TYPE,
1610: p_day IN DATE,
1611: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1612: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE
1613: )
1614: RETURN NUMBER
1615: IS

Line 1677: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,

1673:
1674: PROCEDURE day_over_24 (
1675: p_batch_id IN NUMBER,
1676: p_person_id IN hxt_timecards.for_person_id%TYPE,
1677: p_assignment_id IN per_all_assignments_f.assignment_id%TYPE,
1678: p_period_id IN hxt_timecards.time_period_id%TYPE,
1679: p_tim_id IN hxt_timecards.id%TYPE,
1680: p_day IN DATE,
1681: p_hol_cal_id IN hxt_holiday_calendars.id%TYPE

Line 1892: from per_all_assignments_f p1,

1888:
1889: CURSOR c_no_mid_period_change (p_person_id in number)
1890: is
1891: select 'Y'
1892: from per_all_assignments_f p1,
1893: hxt_timecards_x tim
1894: where tim.effective_start_date between p1.effective_start_date and p1.effective_end_date
1895: and tim.effective_end_date between p1.effective_start_date and p1.effective_end_date
1896: and p1.person_id = p_person_id