APPS.PAY_MX_PTU_CALC dependencies on PAY_BATCH_HEADERS

Line 59: lv_batch_name pay_batch_headers.batch_name%TYPE;

55: lv_procedure_name VARCHAR2(100);
56:
57: lv_error_message VARCHAR2(200);
58: ln_step NUMBER;
59: lv_batch_name pay_batch_headers.batch_name%TYPE;
60:
61: BEGIN
62: lv_procedure_name := '.get_payroll_action_info';
63:

Line 267: lv_batch_name pay_batch_headers.batch_name%TYPE;

263: ln_asg_set_id NUMBER;
264: ln_legal_employer_id NUMBER;
265: -- lv_incl_temp_EEs VARCHAR2(1);
266: -- ln_min_days_worked NUMBER;
267: lv_batch_name pay_batch_headers.batch_name%TYPE;
268:
269: lv_sql_string VARCHAR2(32000);
270: lv_procedure_name VARCHAR2(100);
271:

Line 524: -- Check if Batch Name already exists in PAY_BATCH_HEADERS

520: ORDER BY paf_pri.person_id,
521: NVL(paf.employment_category, 'MX1_PERM_WRK'),
522: paf_pri.effective_end_date DESC;
523:
524: -- Check if Batch Name already exists in PAY_BATCH_HEADERS
525: CURSOR c_chk_batch_name_exists(cp_batch_name VARCHAR2,
526: cp_business_group_id NUMBER) IS
527: SELECT 'Y'
528: FROM pay_batch_headers

Line 528: FROM pay_batch_headers

524: -- Check if Batch Name already exists in PAY_BATCH_HEADERS
525: CURSOR c_chk_batch_name_exists(cp_batch_name VARCHAR2,
526: cp_business_group_id NUMBER) IS
527: SELECT 'Y'
528: FROM pay_batch_headers
529: WHERE business_group_id = cp_business_group_id
530: AND UPPER(cp_batch_name) = UPPER(batch_name);
531:
532: -- Check if assignment exists for the Process Year of Profit Sharing

Line 564: lv_batch_name pay_batch_headers.batch_name%TYPE;

560: ln_legal_employer_id NUMBER;
561: ln_asg_set_id NUMBER;
562: lv_incl_temp_EEs VARCHAR2(1);
563: ln_min_days_worked NUMBER;
564: lv_batch_name pay_batch_headers.batch_name%TYPE;
565:
566: ln_PTU_action_id NUMBER;
567: ln_employment_category per_all_assignments_f.employment_category%TYPE;
568: ln_ytd_aaid NUMBER;

Line 1188: lv_batch_name pay_batch_headers.batch_name%TYPE;

1184: ln_legal_employer_id NUMBER;
1185: ln_asg_set_id NUMBER;
1186: -- lv_incl_temp_EEs VARCHAR2(1);
1187: -- ln_min_days_worked NUMBER;
1188: lv_batch_name pay_batch_headers.batch_name%TYPE;
1189:
1190: lv_legal_ER_name hr_all_organization_units_tl.name%TYPE;
1191:
1192: ln_tot_share_amt NUMBER;

Line 1245: FROM pay_batch_headers

1241: CURSOR c_get_batch_id(cp_batch_name VARCHAR2,
1242: cp_business_group_id NUMBER) IS
1243:
1244: SELECT batch_id
1245: FROM pay_batch_headers
1246: WHERE business_group_id = cp_business_group_id
1247: AND UPPER(cp_batch_name) = UPPER(batch_name);
1248:
1249: BEGIN

Line 1508: lv_batch_name pay_batch_headers.batch_name%TYPE;

1504: ld_start_date DATE;
1505: ld_date_earned DATE;
1506: ln_legal_employer_id NUMBER;
1507: ln_asg_set_id NUMBER;
1508: lv_batch_name pay_batch_headers.batch_name%TYPE;
1509: lv_legal_ER_name hr_all_organization_units_tl.name%TYPE;
1510:
1511: -- Get the person and assignment IDs
1512: CURSOR c_get_person (cp_start_date DATE,