APPS.PAY_PAYRPANP_XML_PKG dependencies on PAY_CONSOLIDATION_SETS

Line 322: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;

318: l_locking_payroll_condition varchar2(2000);
319: l_mode_desc varchar2(2000);
320: l_order_by varchar2(2000);
321: l_payroll_action_condition varchar2(2000);
322: l_consolidation_set_name pay_consolidation_sets.consolidation_set_name%type;
323: l_consolidation_set_condition varchar2(2000);
324: l_template_name varchar2(2000);
325: l_payroll_name pay_payrolls_f.payroll_name%type;
326: l_business_group_name per_business_groups.name%type;

Line 345: ,consolidation_set_name pay_consolidation_sets.consolidation_set_name%type

341: ,action_type varchar2(30)
342: ,action_number number
343: ,assignment_number per_assignments_f.assignment_number%type
344: ,payroll_name pay_all_payrolls_f.payroll_name%type
345: ,consolidation_set_name pay_consolidation_sets.consolidation_set_name%type
346: );
347:
348: l_report_data report_data_record;
349:

Line 368: from pay_consolidation_sets

364: --
365: cursor csr_get_consolidation_set_name(c_consolidation_set_id number)
366: is
367: select consolidation_set_name
368: from pay_consolidation_sets
369: where consolidation_set_id = c_consolidation_set_id;
370:
371: --
372: --

Line 444: pay_consolidation_sets pcs,

440: pay.payroll_name payroll_name,
441: pcs.consolidation_set_name consolidation_set_name
442:
443: from
444: pay_consolidation_sets pcs,
445: pay_all_payrolls_f pay,
446: per_all_people_f ppf,
447: per_all_assignments_f paf,
448: pay_assignment_actions paa,