[Home] [Help]
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 paa.action_status in ('C','S') --Modified for the bug 10066755
96: paa.assignment_action_id),16))
97: FROM pay_assignment_actions paa,
98: pay_payroll_actions ppa,
99: fnd_sessions ses,
100: per_time_periods ptp
101: WHERE paa.assignment_id = p_asg
102: --AND paa.action_status = 'C'
103: AND paa.action_status in ('C','S') --Modified for the bug 10066755
104: AND ses.session_id = userenv('sessionid')
592: CURSOR get_curr_pay_date IS
593: SELECT nvl(ptp.regular_payment_date , to_date('01-01-0001','DD-MM-YYYY'))
594: FROM per_all_assignments_f papf,
595: pay_all_payrolls_f pap,
596: per_time_periods ptp
597: WHERE papf.assignment_id = p_assignment_id
598: AND p_date_earned BETWEEN papf.effective_start_date and papf.effective_end_date
599: AND pap.payroll_id = papf.payroll_id
600: AND p_date_earned BETWEEN pap.effective_start_date and pap.effective_end_date
815:
816:
817: l_asg_tax_ref hr_soft_coding_keyflex.segment1%TYPE;
818: l_asg_payroll_id pay_payrolls_f.payroll_id%TYPE;
819: l_asg_period_start_date per_time_periods.start_date%TYPE;
820: g_cto_main_iv_id NUMBER;
821: g_cto_ntpp_main_iv_id NUMBER;
822: g_cto_main_ref_id NUMBER;
823: g_cto_ntpp_main_ref_id NUMBER;
825:
826:
827: CURSOR get_asg_period_start_date IS
828: SELECT ptp.start_date
829: FROM per_time_periods ptp
830: WHERE ptp.payroll_id = l_asg_payroll_id
831: AND p_date_earned =ptp.regular_payment_date;
832:
833: CURSOR get_main_payroll_id(p_asg_tax_ref VARCHAR2,p_person_id NUMBER) is
893:
894:
895: CURSOR get_pay_date(p_payroll_id IN NUMBER) IS
896: SELECT nvl(ptp.regular_payment_date , to_date('01-01-0001','DD-MM-YYYY'))
897: FROM per_time_periods ptp
898: WHERE p_date_earned BETWEEN ptp.start_date and ptp.end_date
899: AND ptp.payroll_id =p_payroll_id;
900:
901: l_proc VARCHAR2(50);
1045:
1046: --
1047: CURSOR get_freq IS
1048: SELECT number_per_fiscal_year
1049: FROM per_time_periods ptp,
1050: per_time_period_types ptpt
1051: WHERE p_date_earned BETWEEN ptp.start_date AND ptp.end_Date
1052: AND ptp.payroll_id = l_payroll_id
1053: AND ptp.period_type = ptpt.period_type;
1583: SELECT MAX(ASSIGNMENT_ACTION_ID) assignment_action_id
1584: FROM PAY_PAYROLL_ACTIONS PPA,
1585: PAY_ASSIGNMENT_ACTIONS PAA,
1586: PER_ALL_ASSIGNMENTS_F PAAF,
1587: PER_TIME_PERIODS PTP
1588: WHERE PPA.PAYROLL_ACTION_ID=PAA.PAYROLL_ACTION_ID
1589: AND REGULAR_PAYMENT_DATE = PPA.EFFECTIVE_DATE
1590: AND ptp.TIME_PERIOD_ID = PPA.TIME_PERIOD_ID
1591: AND PAA.ASSIGNMENT_ID = PAAF.ASSIGNMENT_ID