APPS.PAY_US_PSD_UPGRADE_PKG dependencies on PER_BUSINESS_GROUPS

Line 388: per_business_groups pbg

384: l_element_set_id,
385: 'I'
386: FROM pay_element_types_f pet,
387: pay_input_values_f piv,
388: per_business_groups pbg
389: WHERE NVL(pet.legislation_code,'US') = 'US'
390: AND NVL(pet.business_group_id,pbg.business_group_id) = pbg.business_group_id
391: AND pbg.legislation_code = 'US'
392: AND NVL(pbg.date_to,TO_DATE('31-12-4712','DD-MM-YYYY'))

Line 1510: FROM per_business_groups pbg,

1506: p_mode VARCHAR2) IS
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,

Line 1572: l_business_group_name per_business_groups.name%TYPE;

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;
1576: l_balance_load_date DATE;