APPS.PAY_PAYRPENP_XML_PKG dependencies on PAY_ASGS_NOT_PROCESSED_V

Line 458: payroll_name pay_asgs_not_processed_v.payroll_name%type

454: type ref_cursor_type is ref cursor;
455:
456: type detail_rec_type is record
457: (
458: payroll_name pay_asgs_not_processed_v.payroll_name%type
459: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
460: ,order_name pay_asgs_not_processed_v.order_name%type
461: ,full_name pay_asgs_not_processed_v.full_name%type
462: ,user_status pay_asgs_not_processed_v.user_status%type

Line 459: ,assignment_number pay_asgs_not_processed_v.assignment_number%type

455:
456: type detail_rec_type is record
457: (
458: payroll_name pay_asgs_not_processed_v.payroll_name%type
459: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
460: ,order_name pay_asgs_not_processed_v.order_name%type
461: ,full_name pay_asgs_not_processed_v.full_name%type
462: ,user_status pay_asgs_not_processed_v.user_status%type
463: ,period_start_date pay_asgs_not_processed_v.period_start_date%type

Line 460: ,order_name pay_asgs_not_processed_v.order_name%type

456: type detail_rec_type is record
457: (
458: payroll_name pay_asgs_not_processed_v.payroll_name%type
459: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
460: ,order_name pay_asgs_not_processed_v.order_name%type
461: ,full_name pay_asgs_not_processed_v.full_name%type
462: ,user_status pay_asgs_not_processed_v.user_status%type
463: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
464: ,ICX_period_start_date varchar2(30)

Line 461: ,full_name pay_asgs_not_processed_v.full_name%type

457: (
458: payroll_name pay_asgs_not_processed_v.payroll_name%type
459: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
460: ,order_name pay_asgs_not_processed_v.order_name%type
461: ,full_name pay_asgs_not_processed_v.full_name%type
462: ,user_status pay_asgs_not_processed_v.user_status%type
463: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
464: ,ICX_period_start_date varchar2(30)
465: ,period_end_date pay_asgs_not_processed_v.period_end_date%type

Line 462: ,user_status pay_asgs_not_processed_v.user_status%type

458: payroll_name pay_asgs_not_processed_v.payroll_name%type
459: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
460: ,order_name pay_asgs_not_processed_v.order_name%type
461: ,full_name pay_asgs_not_processed_v.full_name%type
462: ,user_status pay_asgs_not_processed_v.user_status%type
463: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
464: ,ICX_period_start_date varchar2(30)
465: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
466: ,ICX_period_end_date varchar2(30)

Line 463: ,period_start_date pay_asgs_not_processed_v.period_start_date%type

459: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
460: ,order_name pay_asgs_not_processed_v.order_name%type
461: ,full_name pay_asgs_not_processed_v.full_name%type
462: ,user_status pay_asgs_not_processed_v.user_status%type
463: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
464: ,ICX_period_start_date varchar2(30)
465: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
466: ,ICX_period_end_date varchar2(30)
467: ,location_code pay_asgs_not_processed_v.location_code%type

Line 465: ,period_end_date pay_asgs_not_processed_v.period_end_date%type

461: ,full_name pay_asgs_not_processed_v.full_name%type
462: ,user_status pay_asgs_not_processed_v.user_status%type
463: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
464: ,ICX_period_start_date varchar2(30)
465: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
466: ,ICX_period_end_date varchar2(30)
467: ,location_code pay_asgs_not_processed_v.location_code%type
468: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
469: ,assignment_id pay_asgs_not_processed_v.assignment_id%type

Line 467: ,location_code pay_asgs_not_processed_v.location_code%type

463: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
464: ,ICX_period_start_date varchar2(30)
465: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
466: ,ICX_period_end_date varchar2(30)
467: ,location_code pay_asgs_not_processed_v.location_code%type
468: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
469: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
470: ,person_id per_people_f.person_id%type
471: ,organization_name pay_asgs_not_processed_v.organization_name%type

Line 468: ,pay_basis pay_asgs_not_processed_v.pay_basis%type

464: ,ICX_period_start_date varchar2(30)
465: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
466: ,ICX_period_end_date varchar2(30)
467: ,location_code pay_asgs_not_processed_v.location_code%type
468: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
469: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
470: ,person_id per_people_f.person_id%type
471: ,organization_name pay_asgs_not_processed_v.organization_name%type
472: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type

Line 469: ,assignment_id pay_asgs_not_processed_v.assignment_id%type

465: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
466: ,ICX_period_end_date varchar2(30)
467: ,location_code pay_asgs_not_processed_v.location_code%type
468: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
469: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
470: ,person_id per_people_f.person_id%type
471: ,organization_name pay_asgs_not_processed_v.organization_name%type
472: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type
473: );

Line 471: ,organization_name pay_asgs_not_processed_v.organization_name%type

467: ,location_code pay_asgs_not_processed_v.location_code%type
468: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
469: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
470: ,person_id per_people_f.person_id%type
471: ,organization_name pay_asgs_not_processed_v.organization_name%type
472: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type
473: );
474:
475: -- Need one cursor for outer group i.e. the master group.

Line 472: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type

468: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
469: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
470: ,person_id per_people_f.person_id%type
471: ,organization_name pay_asgs_not_processed_v.organization_name%type
472: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type
473: );
474:
475: -- Need one cursor for outer group i.e. the master group.
476: csr_master ref_cursor_type;

Line 617: ' from pay_asgs_not_processed_v where period_end_date between :1 and :2 ' ||

613: l_master_statement := 'select ' ||
614: l_group_column1 || ' column1,' ||
615: l_group_column2 || ' column2,' ||
616: l_group_column3 || ' column3 ' ||
617: ' from pay_asgs_not_processed_v where period_end_date between :1 and :2 ' ||
618: l_where_clause || ' group by ' ||
619: l_group_by_clause || ' order by ' ||
620: l_group_by_clause;
621:

Line 639: pay_asgs_not_processed_v

635: person_id person_id,
636: organization_name organization_name,
637: consolidation_set_name consolidation_set_name
638: from
639: pay_asgs_not_processed_v
640: where
641: period_end_date between :1 and :2 ' ||
642: l_where_clause ||
643: ' and NVL ('|| l_group_column1 || ' , ''-1'' ) = NVL( :3, ''-1'')' ||