APPS.PAY_CA_WF_PKG dependencies on PAY_ELEMENT_SETS

Line 829: from pay_element_sets

825: and business_group_id = p_business_group_id;
826:
827: cursor cur_retropay_element_set is
828: select element_set_name
829: from pay_element_sets
830: where element_set_id = to_number(p_retropay_element_set)
831: and business_group_id = p_business_group_id;
832:
833: cursor cur_payroll_element_set is

Line 835: from pay_element_sets

831: and business_group_id = p_business_group_id;
832:
833: cursor cur_payroll_element_set is
834: select element_set_name
835: from pay_element_sets
836: where element_set_id = to_number(p_payroll_element_set)
837: and business_group_id = p_business_group_id;
838:
839: cursor cur_payroll_asg_set is

Line 886: from pay_element_sets

882: and language = userenv('LANG');
883:
884: cursor cur_ele_element_set is
885: select element_set_name
886: from pay_element_sets
887: where element_set_id = to_number(p_ele_element_set)
888: and element_set_type = 'C';
889:
890: cursor cur_ele_element_class is

Line 998: from pay_element_sets

994: and enabled_flag = 'Y';
995:
996: cursor cur_costing_detail_ele_set is
997: select element_set_name
998: from pay_element_sets
999: where element_set_id = to_number(p_cost_detail_ele_set)
1000: and element_set_type = 'C';
1001:
1002: cursor cur_costing_detail_ele_class is

Line 2950: from pay_element_sets

2946: and business_group_id = p_business_group_id;
2947:
2948: cursor cur_retropay_element_set is
2949: select element_set_name
2950: from pay_element_sets
2951: where element_set_id = to_number(p_retropay_element_set)
2952: and business_group_id = p_business_group_id;
2953:
2954: --bug 12704242

Line 2964: from pay_element_sets

2960: and p.business_group_id = p_business_group_id;
2961:
2962: cursor cur_payroll_element_set is
2963: select element_set_name
2964: from pay_element_sets
2965: where element_set_id = to_number(p_payroll_element_set)
2966: and business_group_id = p_business_group_id;
2967:
2968: cursor cur_payroll_asg_set is

Line 3015: from pay_element_sets

3011: and language = userenv('LANG');
3012:
3013: cursor cur_ele_element_set is
3014: select element_set_name
3015: from pay_element_sets
3016: where element_set_id = to_number(p_ele_element_set)
3017: and element_set_type = 'C';
3018:
3019: cursor cur_ele_element_class is

Line 3127: from pay_element_sets

3123: and enabled_flag = 'Y';
3124:
3125: cursor cur_costing_detail_ele_set is
3126: select element_set_name
3127: from pay_element_sets
3128: where element_set_id = to_number(p_cost_detail_ele_set)
3129: and element_set_type = 'C';
3130:
3131: cursor cur_costing_detail_ele_class is