APPS.PAY_GB_STUDENT_LOANS_PKG dependencies on PER_TIME_PERIODS

Line 71: per_time_periods ptp,

67: to_number(substr(max(lpad(paa.action_sequence,15,'0')||
68: paa.assignment_action_id),16))
69: FROM pay_assignment_actions paa,
70: pay_payroll_actions ppa,
71: per_time_periods ptp,
72: fnd_sessions ses
73: WHERE paa.assignment_id = p_asg
74: AND paa.action_status = 'C'
75: AND ses.session_id = userenv('sessionid')

Line 99: per_time_periods ptp

95: paa.assignment_action_id),16))
96: FROM pay_assignment_actions paa,
97: pay_payroll_actions ppa,
98: fnd_sessions ses,
99: per_time_periods ptp
100: WHERE paa.assignment_id = p_asg
101: AND paa.action_status = 'C'
102: AND ses.session_id = userenv('sessionid')
103: AND ptp.payroll_id = ppa.payroll_id

Line 594: per_time_periods ptp

590: CURSOR get_curr_pay_date IS
591: SELECT nvl(ptp.regular_payment_date , to_date('01-01-0001','DD-MM-YYYY'))
592: FROM per_all_assignments_f papf,
593: pay_all_payrolls_f pap,
594: per_time_periods ptp
595: WHERE papf.assignment_id = p_assignment_id
596: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date
597: AND pap.payroll_id = papf.payroll_id
598: AND p_date_earned BETWEEN pap.effective_start_date and pap.effective_end_date

Line 817: l_asg_period_start_date per_time_periods.start_date%TYPE;

813:
814:
815: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
816: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;
817: l_asg_period_start_date per_time_periods.start_date%TYPE;
818: g_cto_main_iv_id NUMBER;
819: g_cto_ntpp_main_iv_id NUMBER;
820: g_cto_main_ref_id NUMBER;
821: g_cto_ntpp_main_ref_id NUMBER;

Line 827: FROM per_time_periods ptp

823:
824:
825: CURSOR get_asg_period_start_date IS
826: SELECT ptp.start_date
827: FROM per_time_periods ptp
828: WHERE ptp.payroll_id = l_asg_payroll_id
829: AND p_date_earned =ptp.regular_payment_date;
830:
831: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) is

Line 895: FROM per_time_periods ptp

891:
892:
893: CURSOR get_pay_date(p_payroll_id IN NUMBER) IS
894: SELECT nvl(ptp.regular_payment_date , to_date('01-01-0001','DD-MM-YYYY'))
895: FROM per_time_periods ptp
896: WHERE p_date_earned BETWEEN ptp.start_date and ptp.end_date
897: AND ptp.payroll_id =p_payroll_id;
898:
899: l_proc VARCHAR2(50);

Line 1047: FROM per_time_periods ptp,

1043:
1044: --
1045: CURSOR get_freq IS
1046: SELECT number_per_fiscal_year
1047: FROM per_time_periods ptp,
1048: per_time_period_types ptpt
1049: WHERE p_date_earned BETWEEN ptp.start_date AND ptp.end_Date
1050: AND ptp.payroll_id = l_payroll_id
1051: AND ptp.period_type = ptpt.period_type;