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 143: from pay_payroll_actions

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

Line 218: ,pay_payroll_actions ppa

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

Line 2337: from pay_payroll_actions paa,

2333: fnd_date.canonical_to_date (action_information19)
2334: action_information19,
2335: fnd_date.canonical_to_date (action_information20)
2336: action_information20
2337: from pay_payroll_actions paa,
2338: pay_assignment_actions assg,
2339: pay_action_information pai
2340: where paa.payroll_action_id = p_payroll_action_id
2341: and assg.payroll_action_id = paa.payroll_action_id

Line 2357: from pay_payroll_actions paa,

2353: p_legal_employer varchar2,
2354: p_local_unit_id varchar2
2355: ) is
2356: select count (*)
2357: from pay_payroll_actions paa,
2358: pay_assignment_actions assg,
2359: pay_action_information pai
2360: where paa.payroll_action_id = p_payroll_action_id
2361: and assg.payroll_action_id = paa.payroll_action_id

Line 2387: from pay_payroll_actions ppa,

2383: if p_payroll_action_id is null then
2384: begin
2385: select payroll_action_id
2386: into l_payroll_action_id
2387: from pay_payroll_actions ppa,
2388: fnd_conc_req_summary_v fcrs,
2389: fnd_conc_req_summary_v fcrs1
2390: where fcrs.request_id = fnd_global.conc_request_id
2391: and fcrs.priority_request_id = fcrs1.priority_request_id