APPS.PQP_CAR_MILEAGE_FUNCTIONS dependencies on PER_TIME_PERIODS

Line 914: FROM per_time_periods

910: RETURN NUMBER IS
911:
912: CURSOR period_type IS
913: SELECT period_type
914: FROM per_time_periods
915: WHERE payroll_id = p_payroll_id;
916:
917: CURSOR period_cur(pdate DATE) IS
918: SELECT period_num, period_type,start_date,end_date

Line 919: FROM per_time_periods

915: WHERE payroll_id = p_payroll_id;
916:
917: CURSOR period_cur(pdate DATE) IS
918: SELECT period_num, period_type,start_date,end_date
919: FROM per_time_periods
920: WHERE payroll_id = p_payroll_id
921: AND pdate
922: BETWEEN start_date AND end_date;
923:

Line 926: FROM per_time_periods

922: BETWEEN start_date AND end_date;
923:
924: CURSOR max_period (pdate DATE) IS
925: SELECT period_num
926: FROM per_time_periods
927: WHERE payroll_id=p_payroll_id
928: AND end_date >=pdate
929: ORDER BY end_date;
930:

Line 931: l_period_num per_time_periods.period_num%TYPE;

927: WHERE payroll_id=p_payroll_id
928: AND end_date >=pdate
929: ORDER BY end_date;
930:
931: l_period_num per_time_periods.period_num%TYPE;
932: l_period_type per_time_periods.period_type%TYPE;
933: l_multiple NUMBER;
934: l_base_period_type VARCHAR2(100);
935: l_periods NUMBER;

Line 932: l_period_type per_time_periods.period_type%TYPE;

928: AND end_date >=pdate
929: ORDER BY end_date;
930:
931: l_period_num per_time_periods.period_num%TYPE;
932: l_period_type per_time_periods.period_type%TYPE;
933: l_multiple NUMBER;
934: l_base_period_type VARCHAR2(100);
935: l_periods NUMBER;
936: l_start_date DATE;

Line 943: l_periodtype per_time_periods.period_type%TYPE;

939: l_date DATE;
940: l_max_period NUMBER:=0;
941: c_max_period max_period%ROWTYPE;
942: l_max_period_num NUMBER;
943: l_periodtype per_time_periods.period_type%TYPE;
944: l_effective_date DATE;
945: BEGIN
946: l_effective_date :=TRUNC(pqp_car_mileage_functions.
947: pqp_get_date_paid(p_payroll_action_id));

Line 989: FROM per_time_periods

985: AND p_claim_date < TO_DATE('06/04/'||TO_CHAR(TRUNC(p_claim_date),'RRRR'),'DD/MM/RRRR'))
986: AND l_effective_date >=TO_DATE('06/04/'||TO_CHAR(TRUNC(p_claim_date),'RRRR'),'DD/MM/RRRR') THEN
987:
988: SELECT MAX(period_num) INTO l_max_period_num
989: FROM per_time_periods
990: WHERE payroll_id = p_payroll_id
991: AND end_date >= ADD_MONTHS(to_date('06/04/'||TO_CHAR(TRUNC(p_claim_date),'RRRR'),'DD/MM/RRRR'),-6)
992: AND end_date <= to_date('06/04/'||TO_CHAR(TRUNC(p_claim_date),'RRRR'),'DD/MM/RRRR');
993:

Line 2665: per_time_periods PERIOD

2661: AND EXISTS (select 'Y'
2662: from pay_run_results RESULT,
2663: pay_assignment_actions ASGT_ACTION,
2664: pay_payroll_actions PAY_ACTION,
2665: per_time_periods PERIOD
2666: where result.source_id = pev.element_entry_id --nvl (p_original_entry_id, p_element_entry_id)
2667: and result.status <> 'U'
2668: and result.source_type = 'E'
2669: and result.assignment_action_id = asgt_action.assignment_action_id