APPS.PAY_US_PAYSLIP_SIMULATION_MAIN dependencies on PER_BUSINESS_GROUPS

Line 191: FROM per_business_groups pbg

187: CURSOR get_legislation_code(cp_business_group_id NUMBER,
188: cp_effective_date DATE)
189: IS
190: SELECT pbg.legislation_code
191: FROM per_business_groups pbg
192: WHERE pbg.business_group_id = cp_business_group_id
193: AND cp_effective_date BETWEEN pbg.date_from
194: AND NVL(pbg.date_to,TO_DATE('31/12/4712','DD/MM/YYYY'));
195:

Line 1344: FROM per_business_groups pbg

1340: CURSOR get_legislation_code(cp_business_group_id NUMBER,
1341: cp_effective_date DATE)
1342: IS
1343: SELECT pbg.legislation_code
1344: FROM per_business_groups pbg
1345: WHERE pbg.business_group_id = cp_business_group_id
1346: AND cp_effective_date BETWEEN pbg.date_from
1347: AND NVL(pbg.date_to,TO_DATE('31/12/4712','DD/MM/YYYY'));
1348:

Line 1418: lv_legislation_code per_business_groups.legislation_code%TYPE;

1414:
1415: ln_proposed_salary NUMBER(20,5);
1416: ln_pay_annualization_factor NUMBER(20,5);
1417:
1418: lv_legislation_code per_business_groups.legislation_code%TYPE;
1419:
1420: lv_exists VARCHAR2(1);
1421: ln_index1 number;
1422:

Line 4573: FROM per_business_groups pbg,

4569:
4570: CURSOR get_legislation_code(cp_business_group_id NUMBER)
4571: IS
4572: SELECT pbg.legislation_code
4573: FROM per_business_groups pbg,
4574: fnd_sessions fs
4575: WHERE pbg.business_group_id = cp_business_group_id
4576: AND fs.session_id = USERENV('SESSIONID')
4577: AND fs.effective_date BETWEEN pbg.date_from