[Home] [Help]
26: l_proc varchar2(61) := c_package || 'populate_b';
27: --
28: cursor csr_b1 is
29: select count(*)
30: from pay_assignment_actions paa,
31: pay_payroll_actions ppa,
32: hr_organization_units bp,
33: hr_organization_information hoi1,
34: hr_organization_information hoi2
56:
57: cursor csr_b3 (p_user_entity_id in ff_user_entities.user_entity_id%type) is
58: select nvl(sum(greatest(to_number(i1.value), 0)), 0)
59: from ff_archive_items i1,
60: pay_assignment_actions paa,
61: pay_payroll_actions ppa,
62: hr_organization_units bp,
63: hr_organization_information hoi1,
64: hr_organization_information hoi2
89: cursor csr_b2 is
90: select
91: count(*)
92: from per_assignment_extra_info aei,
93: pay_assignment_actions paa,
94: pay_payroll_actions ppa,
95: hr_organization_units bp,
96: hr_organization_information hoi1,
97: hr_organization_information hoi2
220: -- Re-YEA action if e-file is printed for re-yea
221: ------------------------------------------------------------------------
222: function latest_yea_action(
223: ------------------------------------------------------------------------
224: p_asg_action_id in pay_assignment_actions.assignment_action_id%type,
225: p_pact in number,
226: p_target_year in number
227: ) return varchar2
228: ------------------------------------------------------------------------
231: l_is_latest varchar2(1);
232:
233: Cursor is_latest is
234: Select 'Y'
235: from pay_assignment_actions paa,
236: pay_payroll_actions ppa
237: where paa.assignment_action_id = p_asg_action_id
238: and ppa.payroll_action_id = paa.payroll_action_id
239: and not exists
237: where paa.assignment_action_id = p_asg_action_id
238: and ppa.payroll_action_id = paa.payroll_action_id
239: and not exists
240: ( Select assignment_action_id
241: from pay_assignment_actions paa1,
242: pay_payroll_actions ppa1
243: where paa1.assignment_id = paa.assignment_id
244: and ppa1.payroll_action_id = paa1.payroll_action_id
245: and ppa1.action_type in ('B', 'X')