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 3016: from pay_payroll_actions paa,

3012: fnd_date.canonical_to_date(action_information20) action_information20,
3013: action_information21,
3014: fnd_date.canonical_to_date(action_information22) action_information22,
3015: action_information23
3016: from pay_payroll_actions paa,
3017: pay_assignment_actions assg,
3018: pay_action_information pai
3019: where paa.payroll_action_id = p_payroll_action_id
3020: and assg.payroll_action_id = paa.payroll_action_id

Line 3036: from pay_payroll_actions paa,

3032: p_legal_employer varchar2,
3033: p_local_unit_id varchar2
3034: ) is
3035: select count(*)
3036: from pay_payroll_actions paa,
3037: pay_assignment_actions assg,
3038: pay_action_information pai
3039: where paa.payroll_action_id = p_payroll_action_id
3040: and assg.payroll_action_id = paa.payroll_action_id

Line 3065: from pay_payroll_actions ppa,

3061: if p_payroll_action_id is null then
3062: begin
3063: select payroll_action_id
3064: into l_payroll_action_id
3065: from pay_payroll_actions ppa,
3066: fnd_conc_req_summary_v fcrs,
3067: fnd_conc_req_summary_v fcrs1
3068: where fcrs.request_id = fnd_global.conc_request_id
3069: and fcrs.priority_request_id = fcrs1.priority_request_id