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
1516: WHERE pugu.id = p_id
1517: AND pugu.process_type = 'PA'
1518: AND pugu.process_mode = p_mode
1519: AND pugu.process_date = p_date
1566:
1567: l_upgrade_needed VARCHAR2(2);
1568: l_id pay_patch_status.id%TYPE;
1569: l_date DATE;
1570: l_business_group_id pay_balance_validation.business_group_id%TYPE;
1571: l_print_business_group_id pay_balance_validation.business_group_id%TYPE;
1572: l_business_group_name per_business_groups.name%TYPE;
1573: l_balance_name pay_balance_types.balance_name%TYPE;
1574: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
1567: l_upgrade_needed VARCHAR2(2);
1568: l_id pay_patch_status.id%TYPE;
1569: l_date DATE;
1570: l_business_group_id pay_balance_validation.business_group_id%TYPE;
1571: l_print_business_group_id pay_balance_validation.business_group_id%TYPE;
1572: l_business_group_name per_business_groups.name%TYPE;
1573: l_balance_name pay_balance_types.balance_name%TYPE;
1574: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
1575: l_balance_validation_id pay_balance_validation.balance_validation_id%TYPE;
1571: l_print_business_group_id pay_balance_validation.business_group_id%TYPE;
1572: l_business_group_name per_business_groups.name%TYPE;
1573: l_balance_name pay_balance_types.balance_name%TYPE;
1574: l_dimension_name pay_balance_dimensions.dimension_name%TYPE;
1575: l_balance_validation_id pay_balance_validation.balance_validation_id%TYPE;
1576: l_balance_load_date DATE;
1577:
1578: BEGIN
1579:
1658: END IF;
1659:
1660: IF p_mode = 'UPGRADE' THEN
1661:
1662: UPDATE pay_balance_validation
1663: SET run_balance_status = 'I'
1664: WHERE balance_validation_id = l_balance_validation_id;
1665:
1666: END IF;