APPS.PAY_NO_EERR_STATUS_CONTROL dependencies on PAY_PAYROLL_ACTIONS

Line 57: l_parameter pay_payroll_actions.legislative_parameters%type := null;

53: p_token in varchar2,
54: p_segment_number in number default null
55: )
56: return varchar2 is
57: l_parameter pay_payroll_actions.legislative_parameters%type := null;
58: l_start_pos number;
59: l_delimiter varchar2 (1) := ' ';
60: l_proc varchar2 (240) := g_package || ' get parameter ';
61: begin

Line 141: from pay_payroll_actions

137: legislative_parameters,
138: 'ARCHIVE'
139: ),
140: effective_date, business_group_id
141: from pay_payroll_actions
142: where payroll_action_id = p_payroll_action_id;
143:
144: l_proc varchar2 (240) := g_package || ' GET_ALL_PARAMETERS ';
145: --

Line 215: ,pay_payroll_actions ppa

211:
212: p_sql :=
213: 'SELECT DISTINCT person_id
214: FROM per_people_f ppf
215: ,pay_payroll_actions ppa
216: WHERE ppa.payroll_action_id = :payroll_action_id
217: AND ppa.business_group_id = ppf.business_group_id
218: ORDER BY ppf.person_id';
219: --

Line 2160: from pay_payroll_actions paa,

2156: fnd_date.canonical_to_date (action_information19)
2157: action_information19,
2158: fnd_date.canonical_to_date (action_information20)
2159: action_information20
2160: from pay_payroll_actions paa,
2161: pay_assignment_actions assg,
2162: pay_action_information pai
2163: where paa.payroll_action_id = p_payroll_action_id
2164: and assg.payroll_action_id = paa.payroll_action_id

Line 2180: from pay_payroll_actions paa,

2176: p_legal_employer varchar2,
2177: p_local_unit_id varchar2
2178: ) is
2179: select count (*)
2180: from pay_payroll_actions paa,
2181: pay_assignment_actions assg,
2182: pay_action_information pai
2183: where paa.payroll_action_id = p_payroll_action_id
2184: and assg.payroll_action_id = paa.payroll_action_id

Line 2210: from pay_payroll_actions ppa,

2206: if p_payroll_action_id is null then
2207: begin
2208: select payroll_action_id
2209: into l_payroll_action_id
2210: from pay_payroll_actions ppa,
2211: fnd_conc_req_summary_v fcrs,
2212: fnd_conc_req_summary_v fcrs1
2213: where fcrs.request_id = fnd_global.conc_request_id
2214: and fcrs.priority_request_id = fcrs1.priority_request_id