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

Line 516: FROM per_all_assignments_f pasf,per_time_periods ptp

512: CURSOR c_get_start_end_date(c_assignment_id in NUMBER,
513: c_effective_date IN DATE
514: ) IS
515: SELECT ptp.start_date,ptp.end_date
516: FROM per_all_assignments_f pasf,per_time_periods ptp
517: WHERE pasf.payroll_id = ptp.payroll_id
518: AND pasf.assignment_id = c_assignment_id
519: AND trunc(c_effective_date) BETWEEN ptp.start_date AND ptp.end_date;
520:

Line 595: l_payroll_period per_time_periods.period_name%TYPE;

591: l_average_days_multiplier NUMBER;
592: l_prorated_amount NUMBER;
593: l_avg_days_in_year NUMBER;
594: l_ret_val NUMBER;
595: l_payroll_period per_time_periods.period_name%TYPE;
596: l_work_pattern VARCHAR2(200);
597: l_pay_start_dt DATE;
598: l_pay_end_dt DATE;
599: l_term_date DATE;

Line 3152: l_period_start_dt per_time_periods.start_date%type;

3148: l_defined_bal_id number;
3149: l_payroll_id pay_payrolls_f.payroll_id%type;
3150: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;
3151: l_cur_payroll_id pay_payrolls_f.payroll_id%type;
3152: l_period_start_dt per_time_periods.start_date%type;
3153: l_period_end_dt per_time_periods.end_date%type;
3154: l_time_period_id number;
3155: l_is_abp_pt number := 0;
3156: l_participation_st_dt date;

Line 3153: l_period_end_dt per_time_periods.end_date%type;

3149: l_payroll_id pay_payrolls_f.payroll_id%type;
3150: l_ass_act_id pay_assignment_actions.assignment_action_id%type := -1;
3151: l_cur_payroll_id pay_payrolls_f.payroll_id%type;
3152: l_period_start_dt per_time_periods.start_date%type;
3153: l_period_end_dt per_time_periods.end_date%type;
3154: l_time_period_id number;
3155: l_is_abp_pt number := 0;
3156: l_participation_st_dt date;
3157: l_ret_val number;

Line 3188: FROM per_time_periods

3184: ,c_effective_date IN DATE) IS
3185: SELECT time_period_id
3186: ,start_date
3187: ,end_date
3188: FROM per_time_periods
3189: WHERE payroll_id = c_payroll_id
3190: AND trunc(start_date) >= c_effective_date
3191: ORDER BY start_date;
3192:

Line 4547: l_time_period_id per_time_periods.time_period_id%type;

4543: l_end_of_prev_yr date;
4544: l_prev_run_year number;
4545: l_payroll_id pay_payrolls_f.payroll_id%type;
4546: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4547: l_time_period_id per_time_periods.time_period_id%type;
4548: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4549: l_start_date per_time_periods.start_date%type;
4550: l_end_date per_time_periods.end_date%type;
4551: l_periods_per_yr number := 1;

Line 4549: l_start_date per_time_periods.start_date%type;

4545: l_payroll_id pay_payrolls_f.payroll_id%type;
4546: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4547: l_time_period_id per_time_periods.time_period_id%type;
4548: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4549: l_start_date per_time_periods.start_date%type;
4550: l_end_date per_time_periods.end_date%type;
4551: l_periods_per_yr number := 1;
4552: l_ret_val number := 0;
4553:

Line 4550: l_end_date per_time_periods.end_date%type;

4546: l_asg_action_id pay_assignment_actions.assignment_action_id%type;
4547: l_time_period_id per_time_periods.time_period_id%type;
4548: l_defined_bal_id pay_defined_balances.defined_balance_id%type;
4549: l_start_date per_time_periods.start_date%type;
4550: l_end_date per_time_periods.end_date%type;
4551: l_periods_per_yr number := 1;
4552: l_ret_val number := 0;
4553:
4554: CURSOR c_get_pension_type_details IS

Line 4594: FROM per_time_periods

4590: ,c_effective_date IN DATE) IS
4591: SELECT time_period_id
4592: ,start_date
4593: ,end_date
4594: FROM per_time_periods
4595: WHERE payroll_id = c_payroll_id
4596: AND trunc(c_effective_date) BETWEEN start_date AND end_date;
4597:
4598: CURSOR c_get_asg_act_id (c_time_period_id IN NUMBER