APPS.PAYWSDYG_PKG dependencies on PAY_TRIGGER_COMPONENTS

Line 1129: FROM pay_trigger_components

1125: -- Get the component we asked for, or all of them if the ID's NULL
1126: CURSOR get_comps(cp_id IN NUMBER,cp_comp IN NUMBER) IS
1127: SELECT component_id,
1128: module_name
1129: FROM pay_trigger_components
1130: WHERE (component_id = cp_comp OR cp_comp IS NULL)
1131: AND (event_id = cp_id OR cp_id IS NULL);
1132: --
1133: BEGIN

Line 2241: FROM pay_trigger_components

2237: -- aren't specific to any legislation, business group or payroll
2238: CURSOR get_globals(cp_id IN NUMBER) IS
2239: SELECT component_id,
2240: module_name
2241: FROM pay_trigger_components
2242: WHERE legislation_code IS NULL
2243: AND business_group_id IS NULL
2244: AND payroll_id IS NULL
2245: AND enabled_flag = 'Y'

Line 2254: FROM pay_trigger_components

2250: CURSOR get_legs(cp_id IN NUMBER) IS
2251: SELECT component_id,
2252: legislation_code,
2253: module_name
2254: FROM pay_trigger_components
2255: WHERE legislation_code IS NOT NULL
2256: AND payroll_id IS NULL
2257: AND business_group_id IS NULL
2258: AND enabled_flag = 'Y'

Line 2268: FROM pay_trigger_components

2264: CURSOR get_buss(cp_id IN NUMBER) IS
2265: SELECT component_id,
2266: business_group_id,
2267: module_name
2268: FROM pay_trigger_components
2269: WHERE legislation_code IS NULL
2270: AND payroll_id IS NULL
2271: AND business_group_id IS NOT NULL
2272: AND enabled_flag = 'Y'

Line 2282: FROM pay_trigger_components

2278: CURSOR get_pays(cp_id IN NUMBER) IS
2279: SELECT component_id,
2280: payroll_id,
2281: module_name
2282: FROM pay_trigger_components
2283: WHERE legislation_code IS NULL
2284: AND business_group_id IS NULL
2285: AND payroll_id IS NOT NULL
2286: AND enabled_flag = 'Y'

Line 2538: FROM pay_trigger_components

2534: --
2535: -- Get all the components that this event uses
2536: CURSOR get_comps(cp_id IN NUMBER) IS
2537: SELECT component_id
2538: FROM pay_trigger_components
2539: WHERE event_id = cp_id;
2540: --
2541: l_tname VARCHAR2(30);
2542: l_action VARCHAR2(1);

Line 2573: FROM pay_trigger_components

2569: FOR l_rec IN get_comps(p_id) LOOP
2570: delete_component_children(l_rec.component_id);
2571: END LOOP;
2572: DELETE
2573: FROM pay_trigger_components
2574: WHERE event_id = p_id;
2575: --
2576: -- Delete the local variable declarations that the trigger uses
2577: DELETE

Line 2964: from pay_trigger_events te, pay_trigger_components tc

2960: FROM pay_trigger_parameters
2961: WHERE parameter_type IN ('I','O')
2962: AND value_name IS NOT NULL
2963: AND usage_id in (select component_id
2964: from pay_trigger_events te, pay_trigger_components tc
2965: where te.event_id = tc.event_id
2966: and triggering_action = cp_type
2967: and te.table_name = cp_table_name)
2968: AND usage_type = 'C'