APPS.PAY_NL_PAYSLIP_ARCHIVE dependencies on PAY_ELEMENT_CLASSIFICATIONS

Line 28: classification_name pay_element_classifications.classification_name%TYPE

24: si_type hr_lookups.meaning%TYPE,
25: element_narrative VARCHAR2(30));
26:
27: TYPE statutory_element_rec IS RECORD (
28: classification_name pay_element_classifications.classification_name%TYPE
29: ,element_name pay_element_types_f.element_name%TYPE
30: ,element_type VARCHAR2(1)
31: ,main_index NUMBER
32: ,archive_flag VARCHAR2(1)

Line 2451: from pay_element_classifications

2447: AND (piv.name ='Pay Value'
2448: OR piv.name ='Days')
2449: AND pet.element_type_id = piv.element_type_id
2450: AND pet.classification_id <> (SELECT classification_id
2451: from pay_element_classifications
2452: where classification_name ='Balance Initialization'
2453: and business_group_id is null
2454: and legislation_code is null)
2455: AND piv1.element_type_id = pet.element_type_id

Line 2747: ,pay_element_classifications pec

2743: ,pay_run_results prr
2744: ,pay_element_types_f pet
2745: ,pay_element_types_f_tl pettl
2746: ,pay_input_values_f piv
2747: ,pay_element_classifications pec
2748: ,pay_element_entries_f pee
2749: WHERE prr.status IN ('P','PA')
2750: AND prr.source_id = pee.element_entry_id
2751: AND pee.CREATOR_TYPE = p_creator_type

Line 2780: ,pay_element_classifications pec

2776: ,pay_run_results prr
2777: ,pay_element_types_f pet
2778: ,pay_element_types_f_tl pettl
2779: ,pay_input_values_f piv
2780: ,pay_element_classifications pec
2781: WHERE prr.status IN ('P','PA')
2782: AND prv.run_result_id = prr.run_result_id
2783: AND prr.assignment_action_id = p_run_assign_action_id
2784: AND prr.element_type_id = pet.element_type_id

Line 2818: ,pay_element_classifications pec

2814: ,pay_run_results prr
2815: ,pay_element_types_f pet
2816: ,pay_element_types_f_tl pettl
2817: ,pay_input_values_f piv
2818: ,pay_element_classifications pec
2819: WHERE prr.status IN ('P','PA')
2820: AND prv.run_result_id = prr.run_result_id
2821: AND prr.assignment_action_id = p_run_assign_action_id
2822: AND prr.element_type_id = pet.element_type_id

Line 2845: ,pay_element_classifications pec

2841: ,p_sub_class_name VARCHAR2
2842: ,p_date_earned DATE) IS
2843: SELECT 1
2844: FROM pay_sub_classification_rules_f pscf
2845: ,pay_element_classifications pec
2846: WHERE pscf.element_type_id = p_element_type_id
2847: AND pscf.classification_id = pec.classification_id
2848: AND pec.classification_name = p_sub_class_name
2849: AND pec.legislation_code = 'NL'

Line 2859: ,pay_element_classifications pec

2855: CURSOR csr_sec_classification_psi_ptx (p_element_type_id NUMBER
2856: ,p_date_earned DATE) IS
2857: SELECT pec.classification_name
2858: FROM pay_sub_classification_rules_f pscf
2859: ,pay_element_classifications pec
2860: WHERE pscf.element_type_id = p_element_type_id
2861: AND pscf.classification_id = pec.classification_id
2862: AND pec.classification_name
2863: IN

Line 2873: l_classification_name pay_element_classifications.classification_name%TYPE;

2869: AND pec.legislation_code = 'NL'
2870: AND p_date_earned BETWEEN pscf.effective_start_date
2871: AND pscf.effective_end_date;
2872:
2873: l_classification_name pay_element_classifications.classification_name%TYPE;
2874: --6359807
2875:
2876: --
2877: CURSOR csr_add_element_values (p_run_assign_action_id NUMBER

Line 2887: ,pay_element_classifications pec

2883: FROM pay_run_result_values prv
2884: ,pay_run_results prr
2885: ,pay_element_types_f pet
2886: ,pay_input_values_f piv
2887: ,pay_element_classifications pec
2888: WHERE prr.status IN ('P','PA')
2889: AND prv.run_result_id = prr.run_result_id
2890: AND prr.assignment_action_id = p_run_assign_action_id
2891: AND prr.element_type_id = pet.element_type_id

Line 3834: from pay_element_classifications

3830: AND piv.input_value_id = pbf.input_value_id
3831: AND piv.name ='Pay Value'
3832: AND pet.element_type_id = piv.element_type_id
3833: AND pet.classification_id <>(SELECT classification_id
3834: from pay_element_classifications
3835: where classification_name ='Balance Initialization'
3836: and business_group_id is null
3837: and legislation_code is null)
3838: AND piv1.element_type_id = pet.element_type_id

Line 4530: from pay_element_classifications

4526: AND piv.input_value_id = pbf.input_value_id
4527: AND piv.name ='Pay Value'
4528: AND pet.element_type_id = piv.element_type_id
4529: AND pet.classification_id <> p_classification_id /*(SELECT classification_id
4530: from pay_element_classifications
4531: where classification_name ='Balance Initialization'
4532: and business_group_id is null
4533: and legislation_code is null) */ -- Bug 5107780
4534: AND prr.element_type_id = pet.element_type_id

Line 4578: from pay_element_classifications

4574: AND piv.input_value_id = pbf.input_value_id
4575: AND piv.name ='Pay Value'
4576: AND pet.element_type_id = piv.element_type_id
4577: AND pet.classification_id <> p_classification_id /*(SELECT classification_id
4578: from pay_element_classifications
4579: where classification_name ='Balance Initialization'
4580: and business_group_id is null
4581: and legislation_code is null) */ -- Bug 5107780
4582: AND prr.element_type_id = pet.element_type_id

Line 4627: from pay_element_classifications

4623: AND piv.input_value_id = pbf.input_value_id
4624: AND piv.name ='Pay Value'
4625: AND pet.element_type_id = piv.element_type_id
4626: AND pet.classification_id <> p_classification_id /*(SELECT classification_id
4627: from pay_element_classifications
4628: where classification_name ='Balance Initialization'
4629: and business_group_id is null
4630: and legislation_code is null) */ -- Bug 5107780
4631: AND piv1.element_type_id = pet.element_type_id

Line 4672: from pay_element_classifications

4668:
4669: /* Bug 5107780*/
4670: CURSOR csr_get_bal_init_class IS
4671: SELECT classification_id
4672: from pay_element_classifications
4673: where classification_name ='Balance Initialization'
4674: and business_group_id is null
4675: and legislation_code is null;
4676: