APPS.PAY_PAYRPENP_XML_PKG dependencies on PAY_ASGS_NOT_PROCESSED_V

Line 454: payroll_name pay_asgs_not_processed_v.payroll_name%type

450: type ref_cursor_type is ref cursor;
451:
452: type detail_rec_type is record
453: (
454: payroll_name pay_asgs_not_processed_v.payroll_name%type
455: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
456: ,order_name pay_asgs_not_processed_v.order_name%type
457: ,full_name pay_asgs_not_processed_v.full_name%type
458: ,user_status pay_asgs_not_processed_v.user_status%type

Line 455: ,assignment_number pay_asgs_not_processed_v.assignment_number%type

451:
452: type detail_rec_type is record
453: (
454: payroll_name pay_asgs_not_processed_v.payroll_name%type
455: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
456: ,order_name pay_asgs_not_processed_v.order_name%type
457: ,full_name pay_asgs_not_processed_v.full_name%type
458: ,user_status pay_asgs_not_processed_v.user_status%type
459: ,period_start_date pay_asgs_not_processed_v.period_start_date%type

Line 456: ,order_name pay_asgs_not_processed_v.order_name%type

452: type detail_rec_type is record
453: (
454: payroll_name pay_asgs_not_processed_v.payroll_name%type
455: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
456: ,order_name pay_asgs_not_processed_v.order_name%type
457: ,full_name pay_asgs_not_processed_v.full_name%type
458: ,user_status pay_asgs_not_processed_v.user_status%type
459: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
460: ,ICX_period_start_date varchar2(30)

Line 457: ,full_name pay_asgs_not_processed_v.full_name%type

453: (
454: payroll_name pay_asgs_not_processed_v.payroll_name%type
455: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
456: ,order_name pay_asgs_not_processed_v.order_name%type
457: ,full_name pay_asgs_not_processed_v.full_name%type
458: ,user_status pay_asgs_not_processed_v.user_status%type
459: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
460: ,ICX_period_start_date varchar2(30)
461: ,period_end_date pay_asgs_not_processed_v.period_end_date%type

Line 458: ,user_status pay_asgs_not_processed_v.user_status%type

454: payroll_name pay_asgs_not_processed_v.payroll_name%type
455: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
456: ,order_name pay_asgs_not_processed_v.order_name%type
457: ,full_name pay_asgs_not_processed_v.full_name%type
458: ,user_status pay_asgs_not_processed_v.user_status%type
459: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
460: ,ICX_period_start_date varchar2(30)
461: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
462: ,ICX_period_end_date varchar2(30)

Line 459: ,period_start_date pay_asgs_not_processed_v.period_start_date%type

455: ,assignment_number pay_asgs_not_processed_v.assignment_number%type
456: ,order_name pay_asgs_not_processed_v.order_name%type
457: ,full_name pay_asgs_not_processed_v.full_name%type
458: ,user_status pay_asgs_not_processed_v.user_status%type
459: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
460: ,ICX_period_start_date varchar2(30)
461: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
462: ,ICX_period_end_date varchar2(30)
463: ,location_code pay_asgs_not_processed_v.location_code%type

Line 461: ,period_end_date pay_asgs_not_processed_v.period_end_date%type

457: ,full_name pay_asgs_not_processed_v.full_name%type
458: ,user_status pay_asgs_not_processed_v.user_status%type
459: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
460: ,ICX_period_start_date varchar2(30)
461: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
462: ,ICX_period_end_date varchar2(30)
463: ,location_code pay_asgs_not_processed_v.location_code%type
464: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
465: ,assignment_id pay_asgs_not_processed_v.assignment_id%type

Line 463: ,location_code pay_asgs_not_processed_v.location_code%type

459: ,period_start_date pay_asgs_not_processed_v.period_start_date%type
460: ,ICX_period_start_date varchar2(30)
461: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
462: ,ICX_period_end_date varchar2(30)
463: ,location_code pay_asgs_not_processed_v.location_code%type
464: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
465: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
466: ,person_id per_people_f.person_id%type
467: ,organization_name pay_asgs_not_processed_v.organization_name%type

Line 464: ,pay_basis pay_asgs_not_processed_v.pay_basis%type

460: ,ICX_period_start_date varchar2(30)
461: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
462: ,ICX_period_end_date varchar2(30)
463: ,location_code pay_asgs_not_processed_v.location_code%type
464: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
465: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
466: ,person_id per_people_f.person_id%type
467: ,organization_name pay_asgs_not_processed_v.organization_name%type
468: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type

Line 465: ,assignment_id pay_asgs_not_processed_v.assignment_id%type

461: ,period_end_date pay_asgs_not_processed_v.period_end_date%type
462: ,ICX_period_end_date varchar2(30)
463: ,location_code pay_asgs_not_processed_v.location_code%type
464: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
465: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
466: ,person_id per_people_f.person_id%type
467: ,organization_name pay_asgs_not_processed_v.organization_name%type
468: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type
469: );

Line 467: ,organization_name pay_asgs_not_processed_v.organization_name%type

463: ,location_code pay_asgs_not_processed_v.location_code%type
464: ,pay_basis pay_asgs_not_processed_v.pay_basis%type
465: ,assignment_id pay_asgs_not_processed_v.assignment_id%type
466: ,person_id per_people_f.person_id%type
467: ,organization_name pay_asgs_not_processed_v.organization_name%type
468: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type
469: );
470:
471: -- Need one cursor for outer group i.e. the master group.

Line 468: ,consolidation_set_name pay_asgs_not_processed_v.consolidation_set_name%type

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

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

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

Line 635: pay_asgs_not_processed_v

631: person_id person_id,
632: organization_name organization_name,
633: consolidation_set_name consolidation_set_name
634: from
635: pay_asgs_not_processed_v
636: where
637: period_end_date between :1 and :2 ' ||
638: l_where_clause ||
639: ' and NVL ('|| l_group_column1 || ' , ''-1'' ) = NVL( :3, ''-1'')' ||