APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 454: PROCEDURE generate_assignment(p_assignment_id per_all_assignments_f.assignment_id%TYPE,

450: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.perform_initial_setup');
451:
452: END perform_initial_setup;
453:
454: PROCEDURE generate_assignment(p_assignment_id per_all_assignments_f.assignment_id%TYPE,
455: p_id pay_patch_status.id%TYPE,
456: p_date DATE,
457: p_mode VARCHAR2,
458: p_element_set_id pay_element_sets.element_set_id%TYPE) IS

Line 537: l_person_id per_all_assignments_f.person_id%TYPE;

533: l_old_psd_code VARCHAR2(6);
534: l_new_psd_code VARCHAR2(6);
535: l_school_dsts_code VARCHAR2(5);
536: l_jurisdiction_code VARCHAR2(11);
537: l_person_id per_all_assignments_f.person_id%TYPE;
538: l_archive_item_id NUMBER; -- Added for bug 14213838.
539:
540: BEGIN
541:

Line 546: FROM per_all_assignments_f

542: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID :'||p_assignment_id);
543:
544: SELECT person_id
545: INTO l_person_id
546: FROM per_all_assignments_f
547: WHERE assignment_id = p_assignment_id
548: AND rownum = 1;
549:
550: IF p_mode = 'GENERATE' THEN

Line 1003: PROCEDURE upgrade_assignment(p_assignment_id per_all_assignments_f.assignment_id%TYPE,

999: hr_utility.trace('SQLERRM = ' || SQLERRM);
1000:
1001: END;
1002:
1003: PROCEDURE upgrade_assignment(p_assignment_id per_all_assignments_f.assignment_id%TYPE,
1004: p_id pay_patch_status.id%TYPE,
1005: p_date DATE,
1006: p_mode VARCHAR2) IS
1007: PRAGMA AUTONOMOUS_TRANSACTION;

Line 1209: FROM per_all_assignments_f paf,

1205: /*Under GENERATE Mode, we need to identify the Assignments based on the city tax
1206: records. So the Range Cursor is based on pay_us_emp_city_tax_rules_f */
1207:
1208: sqlstr := ' SELECT DISTINCT paf.person_id
1209: FROM per_all_assignments_f paf,
1210: pay_us_emp_city_tax_rules_f pect,
1211: pay_us_modified_geocodes pumg
1212: WHERE pumg.process_type = ''PA''
1213: AND pect.assignment_id = paf.assignment_id

Line 1253: FROM per_all_assignments_f paf

1249:
1250: ELSE
1251:
1252: sqlstr := ' SELECT distinct paf.person_id
1253: FROM per_all_assignments_f paf
1254: WHERE 1=2
1255: AND :pactid IS NOT NULL';
1256:
1257: END IF;

Line 1282: FROM per_all_assignments_f paf,

1278: p_stperson NUMBER,
1279: p_endperson NUMBER
1280: ) IS
1281: SELECT DISTINCT ectr.assignment_id
1282: FROM per_all_assignments_f paf,
1283: pay_us_emp_city_tax_rules_f ectr,
1284: pay_us_modified_geocodes pumg
1285: WHERE pumg.state_code = ectr.state_code
1286: AND pumg.county_code = ectr.county_code

Line 1306: per_all_assignments_f paf

1302: p_mode pay_us_geo_update.process_mode%TYPE
1303: ) IS
1304: SELECT DISTINCT pugu.assignment_id
1305: FROM pay_us_geo_update pugu,
1306: per_all_assignments_f paf
1307: WHERE pugu.id = p_id
1308: AND pugu.process_type = 'PA'
1309: AND pugu.process_mode = p_mode
1310: AND pugu.process_date = p_date

Line 1511: per_all_assignments_f paf,

1507: SELECT DISTINCT pbg.business_group_id,
1508: pbg.name,
1509: pbv.balance_validation_id
1510: FROM per_business_groups pbg,
1511: per_all_assignments_f paf,
1512: pay_us_geo_update pugu,
1513: pay_balance_types pbt,
1514: pay_defined_balances pdb,
1515: pay_balance_validation pbv