APPS.PAY_NO_EERR_CONTINUOUS dependencies on PAY_PAYROLL_ACTIONS

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

58: p_token in varchar2,
59: p_segment_number in number default null
60: )
61: return varchar2 is
62: l_parameter pay_payroll_actions.legislative_parameters%type := null;
63: l_start_pos number;
64: l_delimiter varchar2 (1) := ' ';
65: l_proc varchar2 (240) := g_package || ' get parameter ';
66: begin

Line 165: from pay_payroll_actions

161: legislative_parameters,
162: 'REPORT_MODE'
163: ),*/
164: effective_date, business_group_id
165: from pay_payroll_actions
166: where payroll_action_id = p_payroll_action_id;
167:
168: l_proc varchar2 (240) := g_package || ' GET_ALL_PARAMETERS ';
169: --

Line 243: ,pay_payroll_actions ppa

239:
240: p_sql :=
241: 'SELECT DISTINCT person_id
242: FROM per_people_f ppf
243: ,pay_payroll_actions ppa
244: WHERE ppa.payroll_action_id = :payroll_action_id
245: AND ppa.business_group_id = ppf.business_group_id
246: ORDER BY ppf.person_id';
247: --

Line 3203: from pay_payroll_actions paa,

3199: fnd_date.canonical_to_date(action_information20) action_information20,
3200: action_information21,
3201: fnd_date.canonical_to_date(action_information22) action_information22,
3202: action_information23
3203: from pay_payroll_actions paa,
3204: pay_assignment_actions assg,
3205: pay_action_information pai
3206: where paa.payroll_action_id = p_payroll_action_id
3207: and assg.payroll_action_id = paa.payroll_action_id

Line 3223: from pay_payroll_actions paa,

3219: p_legal_employer varchar2,
3220: p_local_unit_id varchar2
3221: ) is
3222: select count(*)
3223: from pay_payroll_actions paa,
3224: pay_assignment_actions assg,
3225: pay_action_information pai
3226: where paa.payroll_action_id = p_payroll_action_id
3227: and assg.payroll_action_id = paa.payroll_action_id

Line 3252: from pay_payroll_actions ppa,

3248: if p_payroll_action_id is null then
3249: begin
3250: select payroll_action_id
3251: into l_payroll_action_id
3252: from pay_payroll_actions ppa,
3253: fnd_conc_req_summary_v fcrs,
3254: fnd_conc_req_summary_v fcrs1
3255: where fcrs.request_id = fnd_global.conc_request_id
3256: and fcrs.priority_request_id = fcrs1.priority_request_id