APPS.PAY_KR_SEP_FORM_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 296: from pay_assignment_actions

292: --
293: cursor csr_assact
294: is
295: select *
296: from pay_assignment_actions
297: where assignment_action_id = p_source_action_id
298: for update nowait;
299: --
300: l_csr_assact csr_assact%rowtype;

Line 2106: p_assignment_id pay_assignment_actions.assignment_id%type;

2102: p_session_date date)
2103: is
2104: i number;
2105: p_element_type_id pay_element_types.element_type_id%type;
2106: p_assignment_id pay_assignment_actions.assignment_id%type;
2107: l_element_entry_id number;
2108: l_effective_start_date date;
2109: l_effective_end_date date;
2110: l_object_version_number number;

Line 2111: cursor csr_get_element_type_id(p_assignment_id pay_assignment_actions.assignment_id%type,

2107: l_element_entry_id number;
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)

Line 2195: cursor csr_get_element_type_id(p_assignment_id pay_assignment_actions.assignment_id%type,

2191: and has.assignment_set_id = p_assignment_set_id
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)

Line 2266: procedure create_entry_for_assignment(p_assignment_id in pay_assignment_actions.assignment_id%type,

2262: -- Procedure create_entry_for_assignment creates an entry for the assignments which
2263: -- are passed from the Separation Pay form.
2264: --
2265: --------------------------------------------------------------------------------
2266: procedure create_entry_for_assignment(p_assignment_id in pay_assignment_actions.assignment_id%type,
2267: p_element_type_id in pay_element_types.element_type_id%type,
2268: p_business_group_id in pay_element_types.business_group_id%type,
2269: p_entry_type in pay_element_entries_f.entry_type%type,
2270: p_effective_date in date,

Line 2430: function get_employee_status(p_assignment_id pay_assignment_actions.assignment_id%type,

2426: -- 'U' if an employee does not have an Interim Separation Pay run or Separation Pay run.
2427: -- 'P' if an employee has an Interim Separation Pay run or Separation Pay run.
2428: --
2429: --------------------------------------------------------------------------------
2430: function get_employee_status(p_assignment_id pay_assignment_actions.assignment_id%type,
2431: p_run_type_name pay_run_types.run_type_name%type,
2432: p_date_earned date) return varchar2
2433: is
2434: status varchar2(1):='U';

Line 2438: from pay_assignment_actions paa,

2434: status varchar2(1):='U';
2435: cursor csr_get_status
2436: is
2437: select decode(prt.run_type_name,'SEP','P','SEP_I','P','U')
2438: from pay_assignment_actions paa,
2439: pay_payroll_actions ppa,
2440: pay_run_types_f prt
2441: where ppa.payroll_action_id = paa.payroll_action_id
2442: and ppa.run_type_id = prt.run_type_id