DBA Data[Home] [Help]

APPS.PAY_DK_EHOL_CARD_REQUEST dependencies on PER_BUSINESS_GROUPS

Line 1356: p_legislation_code per_business_groups.legislation_code%TYPE;

1352:
1353: l_location VARCHAR2(2000);
1354:
1355: c_data_exchange_dir CONSTANT VARCHAR2 (30) := 'PER_DATA_EXCHANGE_DIR';
1356: p_legislation_code per_business_groups.legislation_code%TYPE;
1357:
1358: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
1359: IS
1360: SELECT legislation_code

Line 1358: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)

1354:
1355: c_data_exchange_dir CONSTANT VARCHAR2 (30) := 'PER_DATA_EXCHANGE_DIR';
1356: p_legislation_code per_business_groups.legislation_code%TYPE;
1357:
1358: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
1359: IS
1360: SELECT legislation_code
1361: FROM per_business_groups
1362: WHERE business_group_id = v_bg_id;

Line 1361: FROM per_business_groups

1357:
1358: CURSOR csr_leg (v_bg_id per_business_groups.business_group_id%TYPE)
1359: IS
1360: SELECT legislation_code
1361: FROM per_business_groups
1362: WHERE business_group_id = v_bg_id;
1363:
1364: l_test_submission varchar2(1);
1365: