APPS.PAY_IP_PAYROLL_ARCH dependencies on PAY_RUN_TYPES_F

Line 2719: FROM pay_run_types_f prt

2715:
2716: CURSOR cur_sepchk_run_type IS
2717: SELECT prt.run_type_id,
2718: prt.shortname
2719: FROM pay_run_types_f prt
2720: WHERE prt.run_method = 'S'
2721: AND prt.legislation_code = gv_legislation_code;
2722:
2723: CURSOR c_balance_type_id IS

Line 2753: lv_shortname pay_run_types_f.shortname%TYPE;

2749: ln_step NUMBER;
2750:
2751: lv_bal_category pay_balance_categories_f.category_name%TYPE;
2752: ln_sep_chk_run_type_id NUMBER;
2753: lv_shortname pay_run_types_f.shortname%TYPE;
2754: lv_legislation_code VARCHAR2(4);
2755: lv_rule_mode VARCHAR2(30);
2756: ln_business_group_id NUMBER;
2757: lv_temp_date DATE;

Line 4204: FROM pay_run_types_f prt

4200: OR (paa.tax_unit_id IS NULL AND cp_tax_unit_id IS NULL))
4201: AND ((paa.source_action_id IS NOT NULL) OR
4202: (paa.source_action_id IS NULL AND paa.run_type_id IS NULL))
4203: AND NOT EXISTS ( SELECT 1
4204: FROM pay_run_types_f prt
4205: WHERE prt.legislation_code = gv_legislation_code
4206: AND prt.run_type_id = paa.run_type_id
4207: AND prt.run_method IN ( 'C', 'S' ) )
4208: ORDER BY paa.action_sequence DESC;

Line 4250: FROM pay_run_types_f prt

4246: OR (paa.tax_unit_id IS NULL AND cp_tax_unit_id IS NULL))
4247: AND NVL(paa.run_type_id,0) NOT IN (gn_sepchk_run_type_id,
4248: gn_np_sepchk_run_type_id)
4249: AND NOT EXISTS ( SELECT 1
4250: FROM pay_run_types_f prt
4251: WHERE prt.legislation_code = cp_legislation_code
4252: AND prt.run_type_id = NVL(paa.run_type_id,0)
4253: AND prt.run_method = 'C' );
4254: