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.PAY_JP_UITE_ARCH_PKG dependencies on PER_TIME_PERIODS

Line 523: ld_insured_start_date per_time_periods.start_date%TYPE;

519: --
520: lt_res_tb gt_insert_wage_info;
521: lc_procedure VARCHAR2(200);
522: ln_count NUMBER;
523: ld_insured_start_date per_time_periods.start_date%TYPE;
524: ld_insured_end_date per_time_periods.end_date%TYPE;
525: lc_duplicate_flag VARCHAR2(1):='N';
526: ln_insured_days NUMBER;
527: ln_ins_rows NUMBER:=0;

Line 524: ld_insured_end_date per_time_periods.end_date%TYPE;

520: lt_res_tb gt_insert_wage_info;
521: lc_procedure VARCHAR2(200);
522: ln_count NUMBER;
523: ld_insured_start_date per_time_periods.start_date%TYPE;
524: ld_insured_end_date per_time_periods.end_date%TYPE;
525: lc_duplicate_flag VARCHAR2(1):='N';
526: ln_insured_days NUMBER;
527: ln_ins_rows NUMBER:=0;
528: ln_row_count NUMBER:=0;

Line 729: FROM per_time_periods PTP

725: CURSOR lcu_period_for_no_assact
726: IS
727: SELECT PTP.start_date,
728: PTP.end_date
729: FROM per_time_periods PTP
730: WHERE PTP.payroll_id = p_payroll_id
731: AND p_termination_date BETWEEN PTP.start_date AND PTP.end_date
732: ORDER BY PTP.start_date DESC;
733: --

Line 737: ld_period_start_date per_time_periods.start_date%TYPE;

733: --
734: ln_diff_mth NUMBER;
735: ld_effective_date pay_payroll_actions.effective_date%TYPE;
736: ld_date_earned pay_payroll_actions.date_earned%TYPE;
737: ld_period_start_date per_time_periods.start_date%TYPE;
738: ld_period_end_date per_time_periods.end_date%TYPE;
739: ld_insured_start_date per_time_periods.start_date%TYPE;
740: ld_insured_end_date per_time_periods.end_date%TYPE;
741: ln_line_number NUMBER:=0;

Line 738: ld_period_end_date per_time_periods.end_date%TYPE;

734: ln_diff_mth NUMBER;
735: ld_effective_date pay_payroll_actions.effective_date%TYPE;
736: ld_date_earned pay_payroll_actions.date_earned%TYPE;
737: ld_period_start_date per_time_periods.start_date%TYPE;
738: ld_period_end_date per_time_periods.end_date%TYPE;
739: ld_insured_start_date per_time_periods.start_date%TYPE;
740: ld_insured_end_date per_time_periods.end_date%TYPE;
741: ln_line_number NUMBER:=0;
742: ln_action_info_id pay_action_information.action_information_id%TYPE;

Line 739: ld_insured_start_date per_time_periods.start_date%TYPE;

735: ld_effective_date pay_payroll_actions.effective_date%TYPE;
736: ld_date_earned pay_payroll_actions.date_earned%TYPE;
737: ld_period_start_date per_time_periods.start_date%TYPE;
738: ld_period_end_date per_time_periods.end_date%TYPE;
739: ld_insured_start_date per_time_periods.start_date%TYPE;
740: ld_insured_end_date per_time_periods.end_date%TYPE;
741: ln_line_number NUMBER:=0;
742: ln_action_info_id pay_action_information.action_information_id%TYPE;
743: ln_obj_version_num pay_action_information.object_version_number%TYPE;

Line 740: ld_insured_end_date per_time_periods.end_date%TYPE;

736: ld_date_earned pay_payroll_actions.date_earned%TYPE;
737: ld_period_start_date per_time_periods.start_date%TYPE;
738: ld_period_end_date per_time_periods.end_date%TYPE;
739: ld_insured_start_date per_time_periods.start_date%TYPE;
740: ld_insured_end_date per_time_periods.end_date%TYPE;
741: ln_line_number NUMBER:=0;
742: ln_action_info_id pay_action_information.action_information_id%TYPE;
743: ln_obj_version_num pay_action_information.object_version_number%TYPE;
744: --

Line 885: ,p_ins_start_date OUT NOCOPY per_time_periods.start_date%TYPE)

881: ,p_termination_date IN per_periods_of_service.actual_termination_date%TYPE
882: ,p_payroll_id IN pay_payrolls_f.payroll_id%TYPE
883: ,p_hire_date IN per_periods_of_service.date_start%TYPE
884: ,p_last_std_process_date IN per_periods_of_service.last_standard_process_date%TYPE
885: ,p_ins_start_date OUT NOCOPY per_time_periods.start_date%TYPE)
886: --***************************************************************************
887: -- PROCEDURE
888: -- proc_sal_arch
889: --

Line 926: ,per_time_periods PTP

922: PAF.effective_start_date,
923: PAF.effective_end_date
924: FROM pay_assignment_actions PAA
925: ,pay_payroll_actions PPA
926: ,per_time_periods PTP
927: ,per_assignments_f PAF
928: WHERE PAA.assignment_id = p_assignment_id
929: AND PAF.assignment_id = PAA.assignment_id
930: AND PAA.action_status = 'C'

Line 963: ,per_time_periods PTP

959: PAF.effective_start_date,
960: PAF.effective_end_date
961: FROM pay_assignment_actions PAA
962: ,pay_payroll_actions PPA
963: ,per_time_periods PTP
964: ,per_assignments_f PAF
965: WHERE PAA.assignment_id = p_assignment_id
966: AND PAF.assignment_id = PAA.assignment_id
967: AND PAA.action_status = 'C'

Line 992: FROM per_time_periods PTP

988: CURSOR lcu_period_for_no_assact
989: IS
990: SELECT PTP.start_date,
991: PTP.end_date
992: FROM per_time_periods PTP
993: WHERE PTP.payroll_id = p_payroll_id
994: AND PTP.start_date BETWEEN add_months(p_termination_date +1,gn_max_period * -1)
995: AND NVL(p_last_std_process_date,PTP.start_date)
996: AND PTP.start_date <= p_termination_date

Line 1103: ld_period_start_date per_time_periods.start_date%TYPE;

1099: --
1100: ln_sal_action_id pay_assignment_actions.assignment_action_id%TYPE;
1101: ld_effective_date pay_payroll_actions.effective_date%TYPE;
1102: ld_date_earned pay_payroll_actions.date_earned%TYPE;
1103: ld_period_start_date per_time_periods.start_date%TYPE;
1104: ld_period_end_date per_time_periods.end_date%TYPE;
1105: ld_insured_start_date per_time_periods.start_date%TYPE;
1106: ld_insured_end_date per_time_periods.end_date%TYPE;
1107: ld_prev_ins_end_date per_time_periods.end_date%TYPE;

Line 1104: ld_period_end_date per_time_periods.end_date%TYPE;

1100: ln_sal_action_id pay_assignment_actions.assignment_action_id%TYPE;
1101: ld_effective_date pay_payroll_actions.effective_date%TYPE;
1102: ld_date_earned pay_payroll_actions.date_earned%TYPE;
1103: ld_period_start_date per_time_periods.start_date%TYPE;
1104: ld_period_end_date per_time_periods.end_date%TYPE;
1105: ld_insured_start_date per_time_periods.start_date%TYPE;
1106: ld_insured_end_date per_time_periods.end_date%TYPE;
1107: ld_prev_ins_end_date per_time_periods.end_date%TYPE;
1108: lc_wage_a_flag VARCHAR2(10) DEFAULT 'N';

Line 1105: ld_insured_start_date per_time_periods.start_date%TYPE;

1101: ld_effective_date pay_payroll_actions.effective_date%TYPE;
1102: ld_date_earned pay_payroll_actions.date_earned%TYPE;
1103: ld_period_start_date per_time_periods.start_date%TYPE;
1104: ld_period_end_date per_time_periods.end_date%TYPE;
1105: ld_insured_start_date per_time_periods.start_date%TYPE;
1106: ld_insured_end_date per_time_periods.end_date%TYPE;
1107: ld_prev_ins_end_date per_time_periods.end_date%TYPE;
1108: lc_wage_a_flag VARCHAR2(10) DEFAULT 'N';
1109: lc_wage_b_flag VARCHAR2(10) DEFAULT 'N';

Line 1106: ld_insured_end_date per_time_periods.end_date%TYPE;

1102: ld_date_earned pay_payroll_actions.date_earned%TYPE;
1103: ld_period_start_date per_time_periods.start_date%TYPE;
1104: ld_period_end_date per_time_periods.end_date%TYPE;
1105: ld_insured_start_date per_time_periods.start_date%TYPE;
1106: ld_insured_end_date per_time_periods.end_date%TYPE;
1107: ld_prev_ins_end_date per_time_periods.end_date%TYPE;
1108: lc_wage_a_flag VARCHAR2(10) DEFAULT 'N';
1109: lc_wage_b_flag VARCHAR2(10) DEFAULT 'N';
1110: lc_sal_a_bal_flag VARCHAR2(1) DEFAULT 'N';

Line 1107: ld_prev_ins_end_date per_time_periods.end_date%TYPE;

1103: ld_period_start_date per_time_periods.start_date%TYPE;
1104: ld_period_end_date per_time_periods.end_date%TYPE;
1105: ld_insured_start_date per_time_periods.start_date%TYPE;
1106: ld_insured_end_date per_time_periods.end_date%TYPE;
1107: ld_prev_ins_end_date per_time_periods.end_date%TYPE;
1108: lc_wage_a_flag VARCHAR2(10) DEFAULT 'N';
1109: lc_wage_b_flag VARCHAR2(10) DEFAULT 'N';
1110: lc_sal_a_bal_flag VARCHAR2(1) DEFAULT 'N';
1111: lc_sal_b_bal_flag VARCHAR2(1) DEFAULT 'N';

Line 1737: ,p_period_start_date IN per_time_periods.start_date%TYPE

1733:
1734: PROCEDURE proc_spb_arch(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1735: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1736: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
1737: ,p_period_start_date IN per_time_periods.start_date%TYPE
1738: ,p_period_end_date IN per_time_periods.end_date%TYPE
1739: ,p_payroll_id IN NUMBER)
1740: --***************************************************************************
1741: -- PROCEDURE

Line 1738: ,p_period_end_date IN per_time_periods.end_date%TYPE

1734: PROCEDURE proc_spb_arch(p_assignment_action_id IN pay_assignment_actions.assignment_action_id%TYPE
1735: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
1736: ,p_effective_date IN pay_payroll_actions.effective_date%TYPE
1737: ,p_period_start_date IN per_time_periods.start_date%TYPE
1738: ,p_period_end_date IN per_time_periods.end_date%TYPE
1739: ,p_payroll_id IN NUMBER)
1740: --***************************************************************************
1741: -- PROCEDURE
1742: -- proc_spb_arch

Line 2701: ld_ins_start_date per_time_periods.start_date%TYPE;

2697: ln_action_info_id pay_action_information.action_information_id%TYPE;
2698: ln_obj_version_num pay_action_information.object_version_number%TYPE;
2699: ln_assignment_id per_all_assignments_f.assignment_id%TYPE;
2700: lc_procedure VARCHAR2(200);
2701: ld_ins_start_date per_time_periods.start_date%TYPE;
2702: --
2703: BEGIN
2704: --
2705: gb_debug := hr_utility.debug_enabled ;