APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PAY_ELEMENT_SETS

Line 356: l_element_set_id pay_element_sets.element_set_id%TYPE;

352: PROCEDURE create_jsd_element_set (p_pay_patch_status_id pay_patch_status.id%TYPE)
353: IS
354: --
355: --
356: l_element_set_id pay_element_sets.element_set_id%TYPE;
357:
358: BEGIN
359:
360: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.create_jsd_element_set');

Line 364: SELECT pay_element_sets_s.nextval

360: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.create_jsd_element_set');
361:
362: /*Create the Element set for Elements having Jurisdiction Code as Input Value*/
363:
364: SELECT pay_element_sets_s.nextval
365: INTO l_element_set_id
366: FROM DUAL;
367:
368: INSERT INTO pay_element_sets

Line 368: INSERT INTO pay_element_sets

364: SELECT pay_element_sets_s.nextval
365: INTO l_element_set_id
366: FROM DUAL;
367:
368: INSERT INTO pay_element_sets
369: (element_set_id,
370: legislation_code,
371: element_set_name,
372: element_set_type)

Line 458: p_element_set_id pay_element_sets.element_set_id%TYPE) IS

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
459:
460: CURSOR get_assignment_actions(p_assignment_id NUMBER) IS
461: SELECT assignment_action_id
462: FROM pay_payroll_actions ppa,

Line 1433: l_element_set_id pay_element_sets.element_set_id%TYPE;

1429: l_payroll_action_id pay_payroll_actions.payroll_action_id%TYPE;
1430: l_object_id pay_assignment_actions.object_id%TYPE;
1431: l_object_type pay_assignment_actions.object_type%TYPE;
1432: l_mode VARCHAR2(8);
1433: l_element_set_id pay_element_sets.element_set_id%TYPE;
1434: l_id pay_patch_status.id%TYPE;
1435: l_date DATE;
1436: l_upgrade_needed VARCHAR2(2);
1437:

Line 1474: FROM pay_element_sets

1470: IF l_mode = 'GENERATE' THEN
1471:
1472: SELECT element_set_id
1473: INTO l_element_set_id
1474: FROM pay_element_sets
1475: WHERE element_set_name = 'US_JSD_ELEMENTS_'||l_id
1476: AND legislation_code = 'US';
1477:
1478: hr_utility.trace(' Element Set Id : '||l_element_set_id);

Line 1869: FROM pay_element_sets

1865:
1866: DELETE FROM pay_element_type_rules
1867: WHERE element_set_id IN
1868: (SELECT element_set_id
1869: FROM pay_element_sets
1870: WHERE element_set_name = 'US_JSD_ELEMENTS_'||l_id);
1871:
1872: DELETE FROM pay_element_sets
1873: WHERE legislation_code = 'US'

Line 1872: DELETE FROM pay_element_sets

1868: (SELECT element_set_id
1869: FROM pay_element_sets
1870: WHERE element_set_name = 'US_JSD_ELEMENTS_'||l_id);
1871:
1872: DELETE FROM pay_element_sets
1873: WHERE legislation_code = 'US'
1874: AND element_set_name = 'US_JSD_ELEMENTS_'||l_id;
1875:
1876: UPDATE pay_patch_status