APPS.PAY_KR_NPA_PKG dependencies on PAY_PAYROLL_ACTIONS

Line 13: report_type pay_payroll_actions.report_type%TYPE,

9: -- Global Variables
10: --
11: TYPE t_pact IS RECORD(
12: payroll_action_id NUMBER,
13: report_type pay_payroll_actions.report_type%TYPE,
14: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
15: report_category pay_payroll_actions.report_category%TYPE,
16: business_group_id NUMBER,
17: effective_date date,

Line 14: report_qualifier pay_payroll_actions.report_qualifier%TYPE,

10: --
11: TYPE t_pact IS RECORD(
12: payroll_action_id NUMBER,
13: report_type pay_payroll_actions.report_type%TYPE,
14: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
15: report_category pay_payroll_actions.report_category%TYPE,
16: business_group_id NUMBER,
17: effective_date date,
18: -- Bug 3506172

Line 15: report_category pay_payroll_actions.report_category%TYPE,

11: TYPE t_pact IS RECORD(
12: payroll_action_id NUMBER,
13: report_type pay_payroll_actions.report_type%TYPE,
14: report_qualifier pay_payroll_actions.report_qualifier%TYPE,
15: report_category pay_payroll_actions.report_category%TYPE,
16: business_group_id NUMBER,
17: effective_date date,
18: -- Bug 3506172
19: bp_np_number hr_organization_information.org_information1%type);

Line 37: FROM pay_payroll_actions ppa

33: end if;
34:
35: p_sqlstr :=
36: 'SELECT DISTINCT ppf.person_id
37: FROM pay_payroll_actions ppa
38: ,per_people_f ppf
39: WHERE ppa.payroll_action_id = :p_payroll_action_id
40: AND ppa.business_group_id = ppf.business_group_id
41: ORDER BY ppf.person_id';

Line 67: FROM pay_payroll_actions ppa

63: ppa.business_group_id,
64: ppa.effective_date,
65: pay_core_utils.get_parameter('BP_NP_NUMBER',ppa.legislative_parameters) -- Bug 3506172
66: INTO g_pact
67: FROM pay_payroll_actions ppa
68: WHERE ppa.payroll_action_id = p_payroll_action_id;
69:
70: if g_debug then
71: hr_utility.set_location(l_proc_name, 20);

Line 97: FROM pay_payroll_actions bppa

93: l_end_date DATE;
94: CURSOR csr_date IS
95: SELECT to_date('01-11-'||to_char(to_number(to_char(fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters)),'YYYY'))-1),'DD-MM-YYYY')
96: ,fnd_date.canonical_to_date(pay_core_utils.get_parameter('REPORTED_DATE',bppa.legislative_parameters))
97: FROM pay_payroll_actions bppa
98: WHERE bppa.payroll_action_id = p_payroll_action_id;
99:
100: ------------------------------------------------------------------------------
101: -- Cursor altered for fix 2928733

Line 110: FROM pay_payroll_actions bppa

106: ,p_end_date in date)
107: IS
108: SELECT distinct ass.assignment_id
109: ,ass.establishment_id
110: FROM pay_payroll_actions bppa
111: ,per_assignments_f ass
112: ,hr_organization_information hoi
113: ,hr_organization_units hou
114: WHERE bppa.payroll_action_id = p_payroll_action_id

Line 127: FROM pay_payroll_actions ppa

123: -- 3453776 : This WHERE clause has been moved from the inner SELECT
124: AND bppa.effective_date between ass.effective_start_date and ass.effective_end_date
125: --
126: AND EXISTS ( SELECT NULL
127: FROM pay_payroll_actions ppa
128: ,pay_assignment_actions paa
129: WHERE ppa.payroll_action_id = paa.payroll_action_id
130: AND paa.assignment_id = ass.assignment_id
131: AND ppa.effective_date BETWEEN p_start_date

Line 137: FROM pay_payroll_actions ppa4

133: AND ppa.action_type in ('R','Q')
134: AND ppa.action_status = 'C'
135: )
136: AND NOT EXISTS( SELECT NULL
137: FROM pay_payroll_actions ppa4
138: ,pay_assignment_actions paa4
139: WHERE paa4.assignment_id = ass.assignment_id
140: AND paa4.source_action_id IS NULL
141: AND paa4.payroll_action_id = ppa4.payroll_action_id