DBA Data[Home] [Help]

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 1454: from per_time_periods

1450: AND p_date_earned BETWEEN asg2.effective_start_date AND asg2.effective_end_date ;
1451: /* bug 16097213 */
1452: CURSOR csr_reg_pay_date (p_time_period_id number) IS
1453: select REGULAR_PAYMENT_DATE
1454: from per_time_periods
1455: where time_period_id = p_time_period_id;
1456:
1457: l_reg_payment_date per_time_periods.regular_payment_date%type;
1458:

Line 1457: l_reg_payment_date per_time_periods.regular_payment_date%type;

1453: select REGULAR_PAYMENT_DATE
1454: from per_time_periods
1455: where time_period_id = p_time_period_id;
1456:
1457: l_reg_payment_date per_time_periods.regular_payment_date%type;
1458:
1459: -------------
1460: rec_person_details csr_person_details%ROWTYPE;
1461: rec_primary_address csr_primary_address%ROWTYPE;

Line 3620: FROM per_time_periods ptp

3616: ptp.time_period_id time_period_id,
3617: ppa.date_earned date_earned,
3618: ppa.effective_date effective_date,
3619: ptp.start_date start_date
3620: FROM per_time_periods ptp
3621: ,pay_payroll_actions ppa
3622: ,pay_assignment_actions paa
3623: WHERE ptp.payroll_id =ppa.payroll_id
3624: AND ppa.payroll_action_id =paa.payroll_action_id

Line 3638: l_end_date per_time_periods.end_date%TYPE;

3634: -----------------
3635: l_archive_payact_id NUMBER;
3636: l_record_count NUMBER;
3637: l_actid NUMBER;
3638: l_end_date per_time_periods.end_date%TYPE;
3639: l_pre_end_date per_time_periods.end_date%TYPE;
3640: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3642: l_date_earned pay_payroll_actions.date_earned%TYPE;

Line 3639: l_pre_end_date per_time_periods.end_date%TYPE;

3635: l_archive_payact_id NUMBER;
3636: l_record_count NUMBER;
3637: l_actid NUMBER;
3638: l_end_date per_time_periods.end_date%TYPE;
3639: l_pre_end_date per_time_periods.end_date%TYPE;
3640: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3642: l_date_earned pay_payroll_actions.date_earned%TYPE;
3643: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;

Line 3640: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;

3636: l_record_count NUMBER;
3637: l_actid NUMBER;
3638: l_end_date per_time_periods.end_date%TYPE;
3639: l_pre_end_date per_time_periods.end_date%TYPE;
3640: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3642: l_date_earned pay_payroll_actions.date_earned%TYPE;
3643: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
3644: l_effective_date pay_payroll_actions.effective_date%TYPE;

Line 3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;

3637: l_actid NUMBER;
3638: l_end_date per_time_periods.end_date%TYPE;
3639: l_pre_end_date per_time_periods.end_date%TYPE;
3640: l_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3641: l_pre_reg_payment_date per_time_periods.regular_payment_date%TYPE;
3642: l_date_earned pay_payroll_actions.date_earned%TYPE;
3643: l_pre_date_earned pay_payroll_actions.date_earned%TYPE;
3644: l_effective_date pay_payroll_actions.effective_date%TYPE;
3645: l_pre_effective_date pay_payroll_actions.effective_date%TYPE;

Line 3650: l_time_period_id per_time_periods.time_period_id%TYPE;

3646: l_run_payact_id NUMBER;
3647: l_action_context_id NUMBER;
3648: g_archive_pact NUMBER;
3649: p_assactid NUMBER;
3650: l_time_period_id per_time_periods.time_period_id%TYPE;
3651: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
3652: l_start_date per_time_periods.start_date%TYPE;
3653: l_pre_start_date per_time_periods.start_date%TYPE;
3654: l_fnd_session NUMBER := 0;

Line 3651: l_pre_time_period_id per_time_periods.time_period_id%TYPE;

3647: l_action_context_id NUMBER;
3648: g_archive_pact NUMBER;
3649: p_assactid NUMBER;
3650: l_time_period_id per_time_periods.time_period_id%TYPE;
3651: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
3652: l_start_date per_time_periods.start_date%TYPE;
3653: l_pre_start_date per_time_periods.start_date%TYPE;
3654: l_fnd_session NUMBER := 0;
3655: l_prev_prepay NUMBER := 0;

Line 3652: l_start_date per_time_periods.start_date%TYPE;

3648: g_archive_pact NUMBER;
3649: p_assactid NUMBER;
3650: l_time_period_id per_time_periods.time_period_id%TYPE;
3651: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
3652: l_start_date per_time_periods.start_date%TYPE;
3653: l_pre_start_date per_time_periods.start_date%TYPE;
3654: l_fnd_session NUMBER := 0;
3655: l_prev_prepay NUMBER := 0;
3656: ------------------

Line 3653: l_pre_start_date per_time_periods.start_date%TYPE;

3649: p_assactid NUMBER;
3650: l_time_period_id per_time_periods.time_period_id%TYPE;
3651: l_pre_time_period_id per_time_periods.time_period_id%TYPE;
3652: l_start_date per_time_periods.start_date%TYPE;
3653: l_pre_start_date per_time_periods.start_date%TYPE;
3654: l_fnd_session NUMBER := 0;
3655: l_prev_prepay NUMBER := 0;
3656: ------------------
3657:

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

4427:
4428: -- cursor to get the reduced tax rule for the period
4429: CURSOR csr_get_reduced_tax_rule (p_asg_act_id number) IS
4430: SELECT ptp.prd_information1
4431: FROM per_time_periods ptp , pay_payroll_actions ppa , pay_assignment_actions paa
4432: WHERE paa.ASSIGNMENT_ACTION_ID = p_asg_act_id
4433: AND ppa.payroll_action_id = paa.PAYROLL_ACTION_ID
4434: AND ppa.time_period_id = ptp.time_period_id ;
4435: