APPS.PAY_PAYRPANP_XML_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 315: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;

311: l_locking_payroll_condition varchar2(2000);
312: l_mode_desc varchar2(2000);
313: l_order_by varchar2(2000);
314: l_payroll_action_condition varchar2(2000);
315: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;
316: l_consolidation_set_condition varchar2(2000);
317: l_template_name varchar2(2000);
318: l_payroll_name pay_payrolls_f.payroll_name%type;
319: l_business_group_name per_business_groups.name%type;

Line 338: ,consolidation_set_name pay_consolidation_sets.consolidation_set_name%type

334: ,action_type varchar2(30)
335: ,action_number number
336: ,assignment_number per_assignments_f.assignment_number%type
337: ,payroll_name pay_all_payrolls_f.payroll_name%type
338: ,consolidation_set_name pay_consolidation_sets.consolidation_set_name%type
339: );
340:
341: l_report_data report_data_record;
342:

Line 361: from pay_consolidation_sets

357: --
358: cursor csr_get_consolidation_set_name(c_consolidation_set_id number)
359: is
360: select consolidation_set_name
361: from pay_consolidation_sets
362: where consolidation_set_id = c_consolidation_set_id;
363:
364: --
365: --

Line 437: pay_consolidation_sets pcs,

433: pay.payroll_name payroll_name,
434: pcs.consolidation_set_name consolidation_set_name
435:
436: from
437: pay_consolidation_sets pcs,
438: pay_all_payrolls_f pay,
439: per_all_people_f ppf,
440: per_all_assignments_f paf,
441: pay_assignment_actions paa,