APPS.PAY_KR_YEA_MAGTAPE_FUN_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 31: pay_payroll_actions ppa,

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
35: where hoi1.org_information2 = p_bp_number --Bug# 2822459

Line 61: pay_payroll_actions ppa,

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
65: where hoi1.org_information2 = p_bp_number --Bug# 2822459

Line 94: pay_payroll_actions ppa,

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
98: where hoi1.org_information2 = p_bp_number --Bug# 2822459

Line 236: pay_payroll_actions ppa

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
240: ( Select assignment_action_id

Line 242: pay_payroll_actions ppa1

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')
246: and paa1.action_status = 'C'