APPS.PAY_KR_SEP_FORM_PKG dependencies on PAY_ELEMENT_TYPE_RULES

Line 2099: p_element_set_id pay_element_type_rules.element_set_id%type,

2095: -- This procedure is overloaded.
2096: --
2097: --------------------------------------------------------------------------------
2098: procedure create_entries(p_assignment_id_tbl g_assignment_id_tbl%type,
2099: p_element_set_id pay_element_type_rules.element_set_id%type,
2100: p_run_type_id pay_run_types.run_type_id%type,
2101: p_business_group_id hr_assignment_sets.business_group_id%type,
2102: p_session_date date)
2103: is

Line 2112: p_element_set_id pay_element_type_rules.element_set_id%type,

2108: l_effective_start_date date;
2109: l_effective_end_date date;
2110: l_object_version_number number;
2111: cursor csr_get_element_type_id(p_assignment_id pay_assignment_actions.assignment_id%type,
2112: p_element_set_id pay_element_type_rules.element_set_id%type,
2113: p_run_type_id pay_run_types.run_type_id%type,
2114: p_business_group_id pay_element_types.business_group_id%type,
2115: p_session_date date)
2116: is

Line 2118: from pay_element_type_rules petr

2114: p_business_group_id pay_element_types.business_group_id%type,
2115: p_session_date date)
2116: is
2117: select petr.element_type_id
2118: from pay_element_type_rules petr
2119: where petr.element_set_id = p_element_set_id
2120: and petr.include_or_exclude = 'I'
2121: and not exists(select null
2122: from pay_element_type_rules petr

Line 2122: from pay_element_type_rules petr

2118: from pay_element_type_rules petr
2119: where petr.element_set_id = p_element_set_id
2120: and petr.include_or_exclude = 'I'
2121: and not exists(select null
2122: from pay_element_type_rules petr
2123: where petr.element_set_id = p_element_set_id
2124: and petr.include_or_exclude = 'E')
2125: and not exists(select null
2126: from pay_element_type_usages_f npetu

Line 2173: p_element_set_id pay_element_type_rules.element_set_id%type,

2169: end if;
2170: end create_entries;
2171: --------------------------------------------------------------------------------
2172: procedure create_entries(p_assignment_set_id hr_assignment_sets.assignment_set_id%type,
2173: p_element_set_id pay_element_type_rules.element_set_id%type,
2174: p_run_type_id pay_run_types.run_type_id%type,
2175: p_business_group_id hr_assignment_sets.business_group_id%type,
2176: p_payroll_id hr_assignment_sets.payroll_id%type,
2177: p_session_date date)

Line 2196: p_element_set_id pay_element_type_rules.element_set_id%type,

2192: and has.payroll_id = p_payroll_id
2193: and hasa.assignment_set_id = has.assignment_set_id
2194: and hasa.include_or_exclude = 'I';
2195: cursor csr_get_element_type_id(p_assignment_id pay_assignment_actions.assignment_id%type,
2196: p_element_set_id pay_element_type_rules.element_set_id%type,
2197: p_run_type_id pay_run_types.run_type_id%type,
2198: p_business_group_id pay_element_types.business_group_id%type,
2199: p_session_date date)
2200: is

Line 2202: from pay_element_type_rules petr

2198: p_business_group_id pay_element_types.business_group_id%type,
2199: p_session_date date)
2200: is
2201: select petr.element_type_id
2202: from pay_element_type_rules petr
2203: where petr.element_set_id = p_element_set_id
2204: and petr.include_or_exclude = 'I'
2205: and not exists(select null
2206: from pay_element_type_rules petr

Line 2206: from pay_element_type_rules petr

2202: from pay_element_type_rules petr
2203: where petr.element_set_id = p_element_set_id
2204: and petr.include_or_exclude = 'I'
2205: and not exists(select null
2206: from pay_element_type_rules petr
2207: where petr.element_set_id = p_element_set_id
2208: and petr.include_or_exclude = 'E')
2209: and not exists(select null
2210: from pay_element_type_usages_f npetu