53: lv_procedure_name VARCHAR2(100);
54:
55: lv_error_message VARCHAR2(200);
56: ln_step NUMBER;
57: lv_batch_name pay_batch_headers.batch_name%TYPE;
58:
59: BEGIN
60: lv_procedure_name := '.get_payroll_action_info';
61:
258: ln_asg_set_id NUMBER;
259: ln_legal_employer_id NUMBER;
260: -- lv_incl_temp_EEs VARCHAR2(1);
261: -- ln_min_days_worked NUMBER;
262: lv_batch_name pay_batch_headers.batch_name%TYPE;
263:
264: lv_sql_string VARCHAR2(32000);
265: lv_procedure_name VARCHAR2(100);
266:
512: ORDER BY paf_pri.person_id,
513: NVL(paf.employment_category, 'MX1_PERM_WRK'),
514: paf_pri.effective_end_date DESC;
515:
516: -- Check if Batch Name already exists in PAY_BATCH_HEADERS
517: CURSOR c_chk_batch_name_exists(cp_batch_name VARCHAR2,
518: cp_business_group_id NUMBER) IS
519: SELECT 'Y'
520: FROM pay_batch_headers
516: -- Check if Batch Name already exists in PAY_BATCH_HEADERS
517: CURSOR c_chk_batch_name_exists(cp_batch_name VARCHAR2,
518: cp_business_group_id NUMBER) IS
519: SELECT 'Y'
520: FROM pay_batch_headers
521: WHERE business_group_id = cp_business_group_id
522: AND UPPER(cp_batch_name) = UPPER(batch_name);
523:
524: -- Check if assignment exists as on the Date Paid for Profit Sharing
550: ln_legal_employer_id NUMBER;
551: ln_asg_set_id NUMBER;
552: lv_incl_temp_EEs VARCHAR2(1);
553: ln_min_days_worked NUMBER;
554: lv_batch_name pay_batch_headers.batch_name%TYPE;
555:
556: ln_PTU_action_id NUMBER;
557: ln_employment_category per_all_assignments_f.employment_category%TYPE;
558: ln_ytd_aaid NUMBER;
1147: ln_legal_employer_id NUMBER;
1148: ln_asg_set_id NUMBER;
1149: -- lv_incl_temp_EEs VARCHAR2(1);
1150: -- ln_min_days_worked NUMBER;
1151: lv_batch_name pay_batch_headers.batch_name%TYPE;
1152:
1153: lv_legal_ER_name hr_all_organization_units_tl.name%TYPE;
1154:
1155: ln_tot_share_amt NUMBER;
1204: CURSOR c_get_batch_id(cp_batch_name VARCHAR2,
1205: cp_business_group_id NUMBER) IS
1206:
1207: SELECT batch_id
1208: FROM pay_batch_headers
1209: WHERE business_group_id = cp_business_group_id
1210: AND UPPER(cp_batch_name) = UPPER(batch_name);
1211:
1212: BEGIN
1467: ld_start_date DATE;
1468: ld_date_earned DATE;
1469: ln_legal_employer_id NUMBER;
1470: ln_asg_set_id NUMBER;
1471: lv_batch_name pay_batch_headers.batch_name%TYPE;
1472: lv_legal_ER_name hr_all_organization_units_tl.name%TYPE;
1473:
1474: -- Get the person and assignment IDs
1475: CURSOR c_get_person