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 377: FROM hxt_pay_element_types_f_ddf_v eltv

373: CURSOR get_ovt_rates_cur IS
374: SELECT eltv.hxt_premium_type,
375: eltv.hxt_premium_amount,
376: eltv.hxt_processing_order
377: FROM hxt_pay_element_types_f_ddf_v eltv
378: WHERE eltv.hxt_earning_category NOT IN ('REG', 'ABS')
379: AND g_DATE_WORKED between eltv.effective_start_date
380: and eltv.effective_end_date
381: AND eltv.element_type_id = p_element_type_id

Line 384: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;

380: and eltv.effective_end_date
381: AND eltv.element_type_id = p_element_type_id
382: ORDER by eltv.hxt_processing_order;
383:
384: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;
385: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
386: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
387:
388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

Line 385: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

381: AND eltv.element_type_id = p_element_type_id
382: ORDER by eltv.hxt_processing_order;
383:
384: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;
385: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
386: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
387:
388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
389: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

Line 386: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;

382: ORDER by eltv.hxt_processing_order;
383:
384: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;
385: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
386: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
387:
388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
389: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
390: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

Line 388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

384: premium_type hxt_pay_element_types_f_ddf_v.hxt_premium_type%TYPE ;
385: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
386: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
387:
388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
389: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
390: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
391:
392: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092

Line 389: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

385: premium_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
386: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
387:
388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
389: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
390: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
391:
392: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
393: -- *********************************

Line 390: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

386: processing_order hxt_pay_element_types_f_ddf_v.hxt_processing_order%TYPE ;
387:
388: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
389: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
390: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
391:
392: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
393: -- *********************************
394: -- ORACLE END Bugs #465434 & #464850

Line 769: l_mult hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;

765: l_retro_batch_id NUMBER(15);
766: l_error_status NUMBER(15);
767: l_sqlerrm CHAR(200);
768:
769: l_mult hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
770: -- Premium override multiple
771: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
772: -- Premium override rate ORA131
773:

Line 771: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;

767: l_sqlerrm CHAR(200);
768:
769: l_mult hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
770: -- Premium override multiple
771: l_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE;
772: -- Premium override rate ORA131
773:
774: l_hours hxt_det_hours_worked_f.hours%TYPE ; -- SIR092
775: l_time_in hxt_det_hours_worked_f.time_in%TYPE ;

Line 793: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

789: l_rowid ROWID;
790: l_object_version_number NUMBER DEFAULT NULL;
791: l_id NUMBER;
792:
793: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
794: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
795: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
796: --
797: -- Cursor to return all premiums for a base hour entry that a person is

Line 794: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

790: l_object_version_number NUMBER DEFAULT NULL;
791: l_id NUMBER;
792:
793: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
794: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
795: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
796: --
797: -- Cursor to return all premiums for a base hour entry that a person is
798: -- entitled to based on earning category rules, premium eligibility

Line 795: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;

791: l_id NUMBER;
792:
793: l_rate_multiple hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
794: l_hourly_rate hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
795: l_amount hxt_pay_element_types_f_ddf_v.hxt_premium_amount%TYPE ;
796: --
797: -- Cursor to return all premiums for a base hour entry that a person is
798: -- entitled to based on earning category rules, premium eligibility
799: -- for a base hour, and being linked to the person's assignment.

Line 811: hxt_pay_element_types_f_ddf_v eltv,

807: per.elt_premium_id, eltt.element_name, eltv.hxt_earning_category,
808: eltv.hxt_premium_type, eltv.hxt_premium_amount,
809: eltv.hxt_processing_order
810: FROM pay_element_links_f ell,
811: hxt_pay_element_types_f_ddf_v eltv,
812: pay_element_types_f elt,
813: pay_element_types_f_tl eltt,
814: hxt_prem_eligblty_rules per,
815: per_all_assignments_f asm

Line 812: pay_element_types_f elt,

808: eltv.hxt_premium_type, eltv.hxt_premium_amount,
809: eltv.hxt_processing_order
810: FROM pay_element_links_f ell,
811: hxt_pay_element_types_f_ddf_v eltv,
812: pay_element_types_f elt,
813: pay_element_types_f_tl eltt,
814: hxt_prem_eligblty_rules per,
815: per_all_assignments_f asm
816: WHERE asm.assignment_id = g_ASSIGNMENT_ID

Line 813: pay_element_types_f_tl eltt,

809: eltv.hxt_processing_order
810: FROM pay_element_links_f ell,
811: hxt_pay_element_types_f_ddf_v eltv,
812: pay_element_types_f elt,
813: pay_element_types_f_tl eltt,
814: hxt_prem_eligblty_rules per,
815: per_all_assignments_f asm
816: WHERE asm.assignment_id = g_ASSIGNMENT_ID
817: AND g_DATE_WORKED between asm.effective_start_date

Line 882: FROM hxt_pay_element_types_f_ddf_v eltv

878: ,eltv.hxt_earning_category --FORMS60
879: ,eltv.hxt_premium_type
880: ,eltv.hxt_premium_amount
881: ,eltv.hxt_processing_order
882: FROM hxt_pay_element_types_f_ddf_v eltv
883: ,pay_element_types_f elt
884: ,pay_element_types_f_tl eltt
885: WHERE elt.element_type_id = p_element_type_id
886: AND g_DATE_WORKED between elt.effective_start_date

Line 883: ,pay_element_types_f elt

879: ,eltv.hxt_premium_type
880: ,eltv.hxt_premium_amount
881: ,eltv.hxt_processing_order
882: FROM hxt_pay_element_types_f_ddf_v eltv
883: ,pay_element_types_f elt
884: ,pay_element_types_f_tl eltt
885: WHERE elt.element_type_id = p_element_type_id
886: AND g_DATE_WORKED between elt.effective_start_date
887: and elt.effective_end_date

Line 884: ,pay_element_types_f_tl eltt

880: ,eltv.hxt_premium_amount
881: ,eltv.hxt_processing_order
882: FROM hxt_pay_element_types_f_ddf_v eltv
883: ,pay_element_types_f elt
884: ,pay_element_types_f_tl eltt
885: WHERE elt.element_type_id = p_element_type_id
886: AND g_DATE_WORKED between elt.effective_start_date
887: and elt.effective_end_date
888: AND eltt.element_type_id = elt.element_type_id

Line 907: FROM hxt_pay_element_types_f_ddf_v eltv

903: -- Get the maximum sequence number of the current detail row
904: --
905: CURSOR get_max_detail_seqno IS
906: SELECT nvl(min(hrw.seqno),9999)
907: FROM hxt_pay_element_types_f_ddf_v eltv
908: ,pay_element_types_f elt
909: ,hxt_det_hours_worked hrw
910: WHERE hrw.tim_id = g_TIM_ID
911: AND hrw.date_worked = g_DATE_WORKED

Line 908: ,pay_element_types_f elt

904: --
905: CURSOR get_max_detail_seqno IS
906: SELECT nvl(min(hrw.seqno),9999)
907: FROM hxt_pay_element_types_f_ddf_v eltv
908: ,pay_element_types_f elt
909: ,hxt_det_hours_worked hrw
910: WHERE hrw.tim_id = g_TIM_ID
911: AND hrw.date_worked = g_DATE_WORKED
912: AND hrw.parent_id = g_ID

Line 946: FROM hxt_pay_element_types_f_ddf_v eltv,

942: hrw.element_type_id, --FORMS60
943: hrw.rowid hrwrowid,
944: eltv.hxt_earning_category,
945: eltv.hxt_premium_type
946: FROM hxt_pay_element_types_f_ddf_v eltv,
947: pay_element_types_f elt,
948: pay_element_types_f_tl eltt,
949: hxt_prem_interact_rules pir,
950: hxt_det_hours_worked hrw -- C421

Line 947: pay_element_types_f elt,

943: hrw.rowid hrwrowid,
944: eltv.hxt_earning_category,
945: eltv.hxt_premium_type
946: FROM hxt_pay_element_types_f_ddf_v eltv,
947: pay_element_types_f elt,
948: pay_element_types_f_tl eltt,
949: hxt_prem_interact_rules pir,
950: hxt_det_hours_worked hrw -- C421
951: WHERE hrw.tim_id = g_TIM_ID

Line 948: pay_element_types_f_tl eltt,

944: eltv.hxt_earning_category,
945: eltv.hxt_premium_type
946: FROM hxt_pay_element_types_f_ddf_v eltv,
947: pay_element_types_f elt,
948: pay_element_types_f_tl eltt,
949: hxt_prem_interact_rules pir,
950: hxt_det_hours_worked hrw -- C421
951: WHERE hrw.tim_id = g_TIM_ID
952: AND hrw.date_worked = g_DATE_WORKED