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_NO_PAYSLIP_ARCHIVE dependencies on PER_TIME_PERIODS

Line 225: FROM per_time_periods ptp

221: SELECT ptp.end_date end_date,
222: ptp.start_date start_date,
223: ptp.period_name period_name,
224: ppf.payroll_name payroll_name
225: FROM per_time_periods ptp
226: ,pay_payroll_actions ppa
227: ,pay_payrolls_f ppf
228: WHERE ptp.payroll_id = ppa.payroll_id
229: AND ppa.payroll_action_id = p_run_payact_id

Line 3609: FROM per_time_periods ptp

3605: ptp.time_period_id time_period_id,
3606: ppa.date_earned date_earned,
3607: ppa.effective_date effective_date,
3608: ptp.start_date start_date
3609: FROM per_time_periods ptp
3610: ,pay_payroll_actions ppa
3611: ,pay_assignment_actions paa
3612: WHERE ptp.payroll_id =ppa.payroll_id
3613: AND ppa.payroll_action_id =paa.payroll_action_id

Line 3627: l_end_date per_time_periods.end_date%TYPE;

3623: -----------------
3624: l_archive_payact_id NUMBER;
3625: l_record_count NUMBER;
3626: l_actid NUMBER;
3627: l_end_date per_time_periods.end_date%TYPE;
3628: l_pre_end_date per_time_periods.end_date%TYPE;
3629: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3630: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3631: l_date_earned pay_payroll_actions.date_earned%TYPE;

Line 3628: l_pre_end_date per_time_periods.end_date%TYPE;

3624: l_archive_payact_id NUMBER;
3625: l_record_count NUMBER;
3626: l_actid NUMBER;
3627: l_end_date per_time_periods.end_date%TYPE;
3628: l_pre_end_date per_time_periods.end_date%TYPE;
3629: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3630: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3631: l_date_earned pay_payroll_actions.date_earned%TYPE;
3632: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

Line 3629: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;

3625: l_record_count NUMBER;
3626: l_actid NUMBER;
3627: l_end_date per_time_periods.end_date%TYPE;
3628: l_pre_end_date per_time_periods.end_date%TYPE;
3629: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3630: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3631: l_date_earned pay_payroll_actions.date_earned%TYPE;
3632: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
3633: l_effective_date pay_payroll_actions.effective_date%TYPE;

Line 3630: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;

3626: l_actid NUMBER;
3627: l_end_date per_time_periods.end_date%TYPE;
3628: l_pre_end_date per_time_periods.end_date%TYPE;
3629: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3630: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3631: l_date_earned pay_payroll_actions.date_earned%TYPE;
3632: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
3633: l_effective_date pay_payroll_actions.effective_date%TYPE;
3634: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

Line 3639: l_time_period_id per_time_periods.time_period_id%TYPE;

3635: l_run_payact_id NUMBER;
3636: l_action_context_id NUMBER;
3637: g_archive_pact NUMBER;
3638: p_assactid NUMBER;
3639: l_time_period_id per_time_periods.time_period_id%TYPE;
3640: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
3641: l_start_date per_time_periods.start_date%TYPE;
3642: l_pre_start_date per_time_periods.start_date%TYPE;
3643: l_fnd_session NUMBER := 0;

Line 3640: l_pre_time_period_id per_time_periods.time_period_id%TYPE;

3636: l_action_context_id NUMBER;
3637: g_archive_pact NUMBER;
3638: p_assactid NUMBER;
3639: l_time_period_id per_time_periods.time_period_id%TYPE;
3640: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
3641: l_start_date per_time_periods.start_date%TYPE;
3642: l_pre_start_date per_time_periods.start_date%TYPE;
3643: l_fnd_session NUMBER := 0;
3644: l_prev_prepay NUMBER := 0;

Line 3641: l_start_date per_time_periods.start_date%TYPE;

3637: g_archive_pact NUMBER;
3638: p_assactid NUMBER;
3639: l_time_period_id per_time_periods.time_period_id%TYPE;
3640: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
3641: l_start_date per_time_periods.start_date%TYPE;
3642: l_pre_start_date per_time_periods.start_date%TYPE;
3643: l_fnd_session NUMBER := 0;
3644: l_prev_prepay NUMBER := 0;
3645: ------------------

Line 3642: l_pre_start_date per_time_periods.start_date%TYPE;

3638: p_assactid NUMBER;
3639: l_time_period_id per_time_periods.time_period_id%TYPE;
3640: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
3641: l_start_date per_time_periods.start_date%TYPE;
3642: l_pre_start_date per_time_periods.start_date%TYPE;
3643: l_fnd_session NUMBER := 0;
3644: l_prev_prepay NUMBER := 0;
3645: ------------------
3646:

Line 4420: FROM per_time_periods ptp , pay_payroll_actions ppa , pay_assignment_actions paa

4416:
4417: -- cursor to get the reduced tax rule for the period
4418: CURSOR csr_get_reduced_tax_rule (p_asg_act_id number) IS
4419: SELECT ptp.prd_information1
4420: FROM per_time_periods ptp , pay_payroll_actions ppa , pay_assignment_actions paa
4421: WHERE paa.ASSIGNMENT_ACTION_ID = p_asg_act_id
4422: AND ppa.payroll_action_id = paa.PAYROLL_ACTION_ID
4423: AND ppa.time_period_id = ptp.time_period_id ;
4424: