APPS.PQP_PENSION_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 474: FROM per_all_assignments_f pasf,per_time_periods ptp

470: CURSOR c_get_start_end_date(c_assignment_id in NUMBER,
471: c_effective_date IN DATE
472: ) IS
473: SELECT ptp.start_date,ptp.end_date
474: FROM per_all_assignments_f pasf,per_time_periods ptp
475: WHERE pasf.payroll_id = ptp.payroll_id
476: AND pasf.assignment_id = c_assignment_id
477: AND trunc(c_effective_date) BETWEEN ptp.start_date AND ptp.end_date;
478:

Line 553: l_payroll_period per_time_periods.period_name%TYPE;

549: l_average_days_multiplier NUMBER;
550: l_prorated_amount NUMBER;
551: l_avg_days_in_year NUMBER;
552: l_ret_val NUMBER;
553: l_payroll_period per_time_periods.period_name%TYPE;
554: l_work_pattern VARCHAR2(200);
555: l_pay_start_dt DATE;
556: l_pay_end_dt DATE;
557: l_term_date DATE;

Line 3055: l_period_start_dt per_time_periods.start_date%type;

3051: l_defined_bal_id number;
3052: l_payroll_id pay_payrolls_f.payroll_id%type;
3053: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;
3054: l_cur_payroll_id pay_payrolls_f.payroll_id%type;
3055: l_period_start_dt per_time_periods.start_date%type;
3056: l_period_end_dt per_time_periods.end_date%type;
3057: l_time_period_id number;
3058: l_is_abp_pt number := 0;
3059: l_participation_st_dt date;

Line 3056: l_period_end_dt per_time_periods.end_date%type;

3052: l_payroll_id pay_payrolls_f.payroll_id%type;
3053: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;
3054: l_cur_payroll_id pay_payrolls_f.payroll_id%type;
3055: l_period_start_dt per_time_periods.start_date%type;
3056: l_period_end_dt per_time_periods.end_date%type;
3057: l_time_period_id number;
3058: l_is_abp_pt number := 0;
3059: l_participation_st_dt date;
3060: l_ret_val number;

Line 3091: FROM per_time_periods

3087: ,c_effective_date IN DATE) IS
3088: SELECT time_period_id
3089: ,start_date
3090: ,end_date
3091: FROM per_time_periods
3092: WHERE payroll_id = c_payroll_id
3093: AND trunc(start_date) >= c_effective_date
3094: ORDER BY start_date;
3095:

Line 4450: l_time_period_id per_time_periods.time_period_id%type;

4446: l_end_of_prev_yr date;
4447: l_prev_run_year number;
4448: l_payroll_id pay_payrolls_f.payroll_id%type;
4449: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4450: l_time_period_id per_time_periods.time_period_id%type;
4451: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4452: l_start_date per_time_periods.start_date%type;
4453: l_end_date per_time_periods.end_date%type;
4454: l_periods_per_yr number := 1;

Line 4452: l_start_date per_time_periods.start_date%type;

4448: l_payroll_id pay_payrolls_f.payroll_id%type;
4449: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4450: l_time_period_id per_time_periods.time_period_id%type;
4451: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4452: l_start_date per_time_periods.start_date%type;
4453: l_end_date per_time_periods.end_date%type;
4454: l_periods_per_yr number := 1;
4455: l_ret_val number := 0;
4456:

Line 4453: l_end_date per_time_periods.end_date%type;

4449: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4450: l_time_period_id per_time_periods.time_period_id%type;
4451: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4452: l_start_date per_time_periods.start_date%type;
4453: l_end_date per_time_periods.end_date%type;
4454: l_periods_per_yr number := 1;
4455: l_ret_val number := 0;
4456:
4457: CURSOR c_get_pension_type_details IS

Line 4497: FROM per_time_periods

4493: ,c_effective_date IN DATE) IS
4494: SELECT time_period_id
4495: ,start_date
4496: ,end_date
4497: FROM per_time_periods
4498: WHERE payroll_id = c_payroll_id
4499: AND trunc(c_effective_date) BETWEEN start_date AND end_date;
4500:
4501: CURSOR c_get_asg_act_id (c_time_period_id IN NUMBER