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_TIME_PAY dependencies on PAY_ELEMENT_TYPES_F

Line 419: FROM hxt_pay_element_types_f_ddf_v eltv

415: CURSOR get_ovt_rates_cur IS
416: SELECT eltv.hxt_premium_type,
417: eltv.hxt_premium_amount,
418: eltv.hxt_processing_order
419: FROM hxt_pay_element_types_f_ddf_v eltv
420: WHERE eltv.hxt_earning_category NOT IN ('REG', 'ABS')
421: AND g_DATE_WORKED between eltv.effective_start_date
422: and eltv.effective_end_date
423: AND eltv.element_type_id = p_element_type_id

Line 426: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;

422: and eltv.effective_end_date
423: AND eltv.element_type_id = p_element_type_id
424: ORDER by eltv.hxt_processing_order;
425:
426: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;
427: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
428: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
429:
430: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

Line 427: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

423: AND eltv.element_type_id = p_element_type_id
424: ORDER by eltv.hxt_processing_order;
425:
426: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;
427: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
428: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
429:
430: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
431: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

Line 428: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;

424: ORDER by eltv.hxt_processing_order;
425:
426: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;
427: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
428: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
429:
430: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
431: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
432: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

Line 430: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

426: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;
427: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
428: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
429:
430: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
431: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
432: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
433:
434: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092

Line 431: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

427: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
428: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
429:
430: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
431: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
432: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
433:
434: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
435: -- *********************************

Line 432: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

428: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
429:
430: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
431: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
432: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
433:
434: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
435: -- *********************************
436: -- ORACLE END Bugs #465434 & #464850

Line 811: l_mult hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;

807: l_retro_batch_id NUMBER(15);
808: l_error_status NUMBER(15);
809: l_sqlerrm CHAR(200);
810:
811: l_mult hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
812: -- Premium override multiple
813: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
814: -- Premium override rate ORA131
815:

Line 813: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;

809: l_sqlerrm CHAR(200);
810:
811: l_mult hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
812: -- Premium override multiple
813: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
814: -- Premium override rate ORA131
815:
816: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
817: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;

Line 835: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

831: l_rowid ROWID;
832: l_object_version_number NUMBER DEFAULT NULL;
833: l_id NUMBER;
834:
835: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
836: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
837: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
838: --
839: -- Cursor to return all premiums for a base hour entry that a person is

Line 836: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

832: l_object_version_number NUMBER DEFAULT NULL;
833: l_id NUMBER;
834:
835: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
836: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
837: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
838: --
839: -- Cursor to return all premiums for a base hour entry that a person is
840: -- entitled to based on earning category rules, premium eligibility

Line 837: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

833: l_id NUMBER;
834:
835: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
836: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
837: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
838: --
839: -- Cursor to return all premiums for a base hour entry that a person is
840: -- entitled to based on earning category rules, premium eligibility
841: -- for a base hour, and being linked to the person's assignment.

Line 853: hxt_pay_element_types_f_ddf_v eltv,

849: per.elt_premium_id, eltt.element_name, eltv.hxt_earning_category,
850: eltv.hxt_premium_type, eltv.hxt_premium_amount,
851: eltv.hxt_processing_order
852: FROM pay_element_links_f ell,
853: hxt_pay_element_types_f_ddf_v eltv,
854: pay_element_types_f elt,
855: pay_element_types_f_tl eltt,
856: hxt_prem_eligblty_rules per,
857: per_all_assignments_f asm

Line 854: pay_element_types_f elt,

850: eltv.hxt_premium_type, eltv.hxt_premium_amount,
851: eltv.hxt_processing_order
852: FROM pay_element_links_f ell,
853: hxt_pay_element_types_f_ddf_v eltv,
854: pay_element_types_f elt,
855: pay_element_types_f_tl eltt,
856: hxt_prem_eligblty_rules per,
857: per_all_assignments_f asm
858: WHERE asm.assignment_id = g_ASSIGNMENT_ID

Line 855: pay_element_types_f_tl eltt,

851: eltv.hxt_processing_order
852: FROM pay_element_links_f ell,
853: hxt_pay_element_types_f_ddf_v eltv,
854: pay_element_types_f elt,
855: pay_element_types_f_tl eltt,
856: hxt_prem_eligblty_rules per,
857: per_all_assignments_f asm
858: WHERE asm.assignment_id = g_ASSIGNMENT_ID
859: AND g_DATE_WORKED between asm.effective_start_date

Line 924: FROM hxt_pay_element_types_f_ddf_v eltv

920: ,eltv.hxt_earning_category --FORMS60
921: ,eltv.hxt_premium_type
922: ,eltv.hxt_premium_amount
923: ,eltv.hxt_processing_order
924: FROM hxt_pay_element_types_f_ddf_v eltv
925: ,pay_element_types_f elt
926: ,pay_element_types_f_tl eltt
927: WHERE elt.element_type_id = p_element_type_id
928: AND g_DATE_WORKED between elt.effective_start_date

Line 925: ,pay_element_types_f elt

921: ,eltv.hxt_premium_type
922: ,eltv.hxt_premium_amount
923: ,eltv.hxt_processing_order
924: FROM hxt_pay_element_types_f_ddf_v eltv
925: ,pay_element_types_f elt
926: ,pay_element_types_f_tl eltt
927: WHERE elt.element_type_id = p_element_type_id
928: AND g_DATE_WORKED between elt.effective_start_date
929: and elt.effective_end_date

Line 926: ,pay_element_types_f_tl eltt

922: ,eltv.hxt_premium_amount
923: ,eltv.hxt_processing_order
924: FROM hxt_pay_element_types_f_ddf_v eltv
925: ,pay_element_types_f elt
926: ,pay_element_types_f_tl eltt
927: WHERE elt.element_type_id = p_element_type_id
928: AND g_DATE_WORKED between elt.effective_start_date
929: and elt.effective_end_date
930: AND eltt.element_type_id = elt.element_type_id

Line 954: FROM hxt_pay_element_types_f_ddf_v eltv

950: -- Get the maximum sequence number of the current detail row
951: --
952: CURSOR get_max_detail_seqno IS
953: SELECT nvl(min(hrw.seqno),9999)
954: FROM hxt_pay_element_types_f_ddf_v eltv
955: ,pay_element_types_f elt
956: ,hxt_det_hours_worked hrw
957: WHERE hrw.tim_id = g_TIM_ID
958: AND hrw.date_worked = g_DATE_WORKED

Line 955: ,pay_element_types_f elt

951: --
952: CURSOR get_max_detail_seqno IS
953: SELECT nvl(min(hrw.seqno),9999)
954: FROM hxt_pay_element_types_f_ddf_v eltv
955: ,pay_element_types_f elt
956: ,hxt_det_hours_worked hrw
957: WHERE hrw.tim_id = g_TIM_ID
958: AND hrw.date_worked = g_DATE_WORKED
959: AND hrw.parent_id = g_ID

Line 993: FROM hxt_pay_element_types_f_ddf_v eltv,

989: hrw.element_type_id, --FORMS60
990: hrw.rowid hrwrowid,
991: eltv.hxt_earning_category,
992: eltv.hxt_premium_type
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: pay_element_types_f_tl eltt,
996: hxt_prem_interact_rules pir,
997: hxt_det_hours_worked hrw -- C421

Line 994: pay_element_types_f elt,

990: hrw.rowid hrwrowid,
991: eltv.hxt_earning_category,
992: eltv.hxt_premium_type
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: pay_element_types_f_tl eltt,
996: hxt_prem_interact_rules pir,
997: hxt_det_hours_worked hrw -- C421
998: WHERE hrw.tim_id = g_TIM_ID

Line 995: pay_element_types_f_tl eltt,

991: eltv.hxt_earning_category,
992: eltv.hxt_premium_type
993: FROM hxt_pay_element_types_f_ddf_v eltv,
994: pay_element_types_f elt,
995: pay_element_types_f_tl eltt,
996: hxt_prem_interact_rules pir,
997: hxt_det_hours_worked hrw -- C421
998: WHERE hrw.tim_id = g_TIM_ID
999: AND hrw.date_worked = g_DATE_WORKED

Line 1033: FROM hxt_pay_element_types_f_ddf_v eltv

1029: -- Get the maximum sequence number of the current detail row
1030: --
1031: CURSOR get_max_detail_seqno IS
1032: SELECT nvl(min(hrw.seqno),9999)
1033: FROM hxt_pay_element_types_f_ddf_v eltv
1034: ,pay_element_types_f elt
1035: ,hxt_det_hours_worked_f hrw
1036: WHERE hrw.tim_id = g_TIM_ID
1037: AND hrw.date_worked = g_DATE_WORKED

Line 1034: ,pay_element_types_f elt

1030: --
1031: CURSOR get_max_detail_seqno IS
1032: SELECT nvl(min(hrw.seqno),9999)
1033: FROM hxt_pay_element_types_f_ddf_v eltv
1034: ,pay_element_types_f elt
1035: ,hxt_det_hours_worked_f hrw
1036: WHERE hrw.tim_id = g_TIM_ID
1037: AND hrw.date_worked = g_DATE_WORKED
1038: AND hrw.parent_id = g_ID

Line 1057: FROM hxt_pay_element_types_f_ddf_v eltv,

1053: hrw.element_type_id, --FORMS60
1054: hrw.rowid hrwrowid,
1055: eltv.hxt_earning_category,
1056: eltv.hxt_premium_type
1057: FROM hxt_pay_element_types_f_ddf_v eltv,
1058: pay_element_types_f elt,
1059: pay_element_types_f_tl eltt,
1060: hxt_prem_interact_rules pir,
1061: hxt_det_hours_worked_f hrw -- C421

Line 1058: pay_element_types_f elt,

1054: hrw.rowid hrwrowid,
1055: eltv.hxt_earning_category,
1056: eltv.hxt_premium_type
1057: FROM hxt_pay_element_types_f_ddf_v eltv,
1058: pay_element_types_f elt,
1059: pay_element_types_f_tl eltt,
1060: hxt_prem_interact_rules pir,
1061: hxt_det_hours_worked_f hrw -- C421
1062: WHERE hrw.tim_id = g_TIM_ID

Line 1059: pay_element_types_f_tl eltt,

1055: eltv.hxt_earning_category,
1056: eltv.hxt_premium_type
1057: FROM hxt_pay_element_types_f_ddf_v eltv,
1058: pay_element_types_f elt,
1059: pay_element_types_f_tl eltt,
1060: hxt_prem_interact_rules pir,
1061: hxt_det_hours_worked_f hrw -- C421
1062: WHERE hrw.tim_id = g_TIM_ID
1063: AND hrw.date_worked = g_DATE_WORKED