DBA Data[Home] [Help]

APPS.PAY_ZA_MTC_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 46: pay_payroll_actions ppa

42: -- for the current Assignment in the same Tax Year
43: cursor other_ass_main is
44: select paa.serial_number, paa.assignment_action_id
45: from pay_assignment_actions paa,
46: pay_payroll_actions ppa
47: where ppa.business_group_id = p_bgid
48: and ppa.report_type = 'ZA_IRP5'
49: and ppa.action_type = 'X'
50: and substr(ppa.legislative_parameters, instr(ppa.legislative_parameters, 'TAX_YEAR') + 9, 4)

Line 68: pay_payroll_actions ppa,

64: -- current Assignment in the same Tax Year, and for a specific Time Period ID
65: cursor other_ass_ls(p_period varchar2) is
66: select paa.serial_number, paa.assignment_action_id
67: from pay_assignment_actions paa,
68: pay_payroll_actions ppa,
69: ff_database_items dbi,
70: ff_archive_items arc
71: where ppa.business_group_id = p_bgid
72: and ppa.report_type = 'ZA_IRP5'

Line 128: From pay_payroll_actions ppa_arch,

124: -- added for 6266019
125:
126: Select decode(count(*), 0 ,'Y', 'N')
127: into l_lump_sum_ind
128: From pay_payroll_actions ppa_arch,
129: pay_assignment_actions paa_arch
130: where paa_arch.assignment_action_id = p_asg_action_id
131: and ppa_arch.payroll_action_id = paa_arch.payroll_action_id
132: and paa_arch.assignment_action_id =