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 2212: FROM pay_trigger_components

2208: -- aren't specific to any legislation, business group or payroll
2209: CURSOR get_globals(cp_id IN NUMBER) IS
2210: SELECT component_id,
2211: module_name
2212: FROM pay_trigger_components
2213: WHERE legislation_code IS NULL
2214: AND business_group_id IS NULL
2215: AND payroll_id IS NULL
2216: AND enabled_flag = 'Y'

Line 2225: FROM pay_trigger_components

2221: CURSOR get_legs(cp_id IN NUMBER) IS
2222: SELECT component_id,
2223: legislation_code,
2224: module_name
2225: FROM pay_trigger_components
2226: WHERE legislation_code IS NOT NULL
2227: AND payroll_id IS NULL
2228: AND business_group_id IS NULL
2229: AND enabled_flag = 'Y'

Line 2239: FROM pay_trigger_components

2235: CURSOR get_buss(cp_id IN NUMBER) IS
2236: SELECT component_id,
2237: business_group_id,
2238: module_name
2239: FROM pay_trigger_components
2240: WHERE legislation_code IS NULL
2241: AND payroll_id IS NULL
2242: AND business_group_id IS NOT NULL
2243: AND enabled_flag = 'Y'

Line 2253: FROM pay_trigger_components

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

Line 2508: FROM pay_trigger_components

2504: --
2505: -- Get all the components that this event uses
2506: CURSOR get_comps(cp_id IN NUMBER) IS
2507: SELECT component_id
2508: FROM pay_trigger_components
2509: WHERE event_id = cp_id;
2510: --
2511: l_tname VARCHAR2(30);
2512: l_action VARCHAR2(1);

Line 2543: FROM pay_trigger_components

2539: FOR l_rec IN get_comps(p_id) LOOP
2540: delete_component_children(l_rec.component_id);
2541: END LOOP;
2542: DELETE
2543: FROM pay_trigger_components
2544: WHERE event_id = p_id;
2545: --
2546: -- Delete the local variable declarations that the trigger uses
2547: DELETE

Line 2927: from pay_trigger_events te, pay_trigger_components tc

2923: FROM pay_trigger_parameters
2924: WHERE parameter_type IN ('I','O')
2925: AND value_name IS NOT NULL
2926: AND usage_id in (select component_id
2927: from pay_trigger_events te, pay_trigger_components tc
2928: where te.event_id = tc.event_id
2929: and triggering_action = cp_type
2930: and te.table_name = cp_table_name)
2931: AND usage_type = 'C'