APPS.PAY_MX_PAYROLL_ARCH dependencies on PAY_RUN_TYPES_F

Line 2644: FROM pay_run_types_f prt

2640:
2641: CURSOR cur_sepchk_run_type IS
2642: SELECT prt.run_type_id,
2643: prt.shortname
2644: FROM pay_run_types_f prt
2645: WHERE prt.run_method = 'S'
2646: AND prt.legislation_code = 'MX';
2647:
2648: CURSOR cur_bal_type IS

Line 2671: lv_shortname pay_run_types_f.shortname%TYPE;

2667: ln_run_bal_type_id NUMBER;
2668: lv_balance_name VARCHAR2(100);
2669: lv_bal_category pay_balance_categories_f.category_name%TYPE;
2670: ln_sep_chk_run_type_id NUMBER;
2671: lv_shortname pay_run_types_f.shortname%TYPE;
2672:
2673: i NUMBER;
2674: j NUMBER;
2675:

Line 4821: FROM pay_run_types_f prt

4817: AND paa.assignment_id = cp_assignment_id
4818: AND paa.tax_unit_id = cp_tax_unit_id
4819: AND paa.source_action_id IS NOT NULL
4820: AND NOT EXISTS ( SELECT 1
4821: FROM pay_run_types_f prt
4822: WHERE prt.legislation_code = 'MX'
4823: AND prt.run_type_id = paa.run_type_id
4824: AND prt.run_method IN ( 'C', 'S' ) )
4825: ORDER BY paa.action_sequence DESC;

Line 4864: FROM pay_run_types_f prt

4860: AND paa.tax_unit_id = cp_tax_unit_id
4861: AND NVL(paa.run_type_id,0) NOT IN (gn_sepchk_run_type_id,
4862: gn_np_sepchk_run_type_id)
4863: AND NOT EXISTS ( SELECT 1
4864: FROM pay_run_types_f prt
4865: WHERE prt.legislation_code = 'US'
4866: AND prt.run_type_id = NVL(paa.run_type_id,0)
4867: AND prt.run_method = 'C' );
4868: