eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_EXPENDITURES_UTILS dependencies on PA_COST_DISTRIBUTION_LINES_ALL

Line 512: FROM PA_COST_DISTRIBUTION_LINES_ALL

508: G_PA_PERIOD_NAME,
509: G_GL_PERIOD_NAME,
510: G_RECVR_PA_PERIOD_NAME,
511: G_RECVR_GL_PERIOD_NAME
512: FROM PA_COST_DISTRIBUTION_LINES_ALL
513: WHERE EXPENDITURE_ITEM_ID = P_EXP_ITEM_ID
514: AND LINE_TYPE = 'R'
515: AND LINE_NUM_REVERSED IS NULL
516: AND REVERSED_FLAG IS NULL ;

Line 583: From pa_cost_distribution_lines_all

579: g_pa_period_name,
580: g_gl_period_name,
581: g_recvr_pa_period_name,
582: g_recvr_Gl_period_name
583: From pa_cost_distribution_lines_all
584: Where expenditure_item_id = P_Exp_Item_Id
585: And line_type = 'R'
586: And line_num = (
587: Select max(line_num)

Line 588: From pa_cost_distribution_lines_all

584: Where expenditure_item_id = P_Exp_Item_Id
585: And line_type = 'R'
586: And line_num = (
587: Select max(line_num)
588: From pa_cost_distribution_lines_all
589: Where expenditure_item_id = P_Exp_Item_Id
590: And line_type = 'R');
591:
592: G_exp_item_id := P_Exp_item_Id;

Line 640: From pa_cost_distribution_lines_all

636: g_pa_period_name,
637: g_gl_period_name,
638: g_recvr_pa_period_name,
639: g_recvr_Gl_period_name
640: From pa_cost_distribution_lines_all
641: Where expenditure_item_id = P_Exp_Item_Id
642: And line_type = 'R'
643: And line_num = (
644: Select max(line_num)

Line 645: From pa_cost_distribution_lines_all

641: Where expenditure_item_id = P_Exp_Item_Id
642: And line_type = 'R'
643: And line_num = (
644: Select max(line_num)
645: From pa_cost_distribution_lines_all
646: Where expenditure_item_id = P_Exp_Item_Id
647: And line_type = 'R');
648:
649: G_exp_item_id := P_Exp_item_Id;

Line 697: From pa_cost_distribution_lines_all

693: g_pa_period_name,
694: g_gl_period_name,
695: g_recvr_pa_period_name,
696: g_recvr_Gl_period_name
697: From pa_cost_distribution_lines_all
698: Where expenditure_item_id = P_Exp_Item_Id
699: And line_type = 'R'
700: And line_num = (
701: Select max(line_num)

Line 702: From pa_cost_distribution_lines_all

698: Where expenditure_item_id = P_Exp_Item_Id
699: And line_type = 'R'
700: And line_num = (
701: Select max(line_num)
702: From pa_cost_distribution_lines_all
703: Where expenditure_item_id = P_Exp_Item_Id
704: And line_type = 'R');
705:
706: G_exp_item_id := P_Exp_item_Id;

Line 755: From pa_cost_distribution_lines_all

751: g_pa_period_name,
752: g_gl_period_name,
753: g_recvr_pa_period_name,
754: g_recvr_Gl_period_name
755: From pa_cost_distribution_lines_all
756: Where expenditure_item_id = P_Exp_Item_Id
757: And line_type = 'R'
758: And line_num = (
759: Select max(line_num)

Line 760: From pa_cost_distribution_lines_all

756: Where expenditure_item_id = P_Exp_Item_Id
757: And line_type = 'R'
758: And line_num = (
759: Select max(line_num)
760: From pa_cost_distribution_lines_all
761: Where expenditure_item_id = P_Exp_Item_Id
762: And line_type = 'R');
763:
764: G_exp_item_id := P_Exp_item_Id;

Line 813: From pa_cost_distribution_lines_all

809: g_pa_period_name,
810: g_gl_period_name,
811: g_recvr_pa_period_name,
812: g_recvr_Gl_period_name
813: From pa_cost_distribution_lines_all
814: Where expenditure_item_id = P_Exp_Item_Id
815: And line_type = 'R'
816: And line_num = (
817: Select max(line_num)

Line 818: From pa_cost_distribution_lines_all

814: Where expenditure_item_id = P_Exp_Item_Id
815: And line_type = 'R'
816: And line_num = (
817: Select max(line_num)
818: From pa_cost_distribution_lines_all
819: Where expenditure_item_id = P_Exp_Item_Id
820: And line_type = 'R');
821:
822: G_exp_item_id := P_Exp_item_Id;

Line 871: From pa_cost_distribution_lines_all

867: g_pa_period_name,
868: g_gl_period_name,
869: g_recvr_pa_period_name,
870: g_recvr_Gl_period_name
871: From pa_cost_distribution_lines_all
872: Where expenditure_item_id = P_Exp_Item_Id
873: And line_type = 'R'
874: And line_num = (
875: Select max(line_num)

Line 876: From pa_cost_distribution_lines_all

872: Where expenditure_item_id = P_Exp_Item_Id
873: And line_type = 'R'
874: And line_num = (
875: Select max(line_num)
876: From pa_cost_distribution_lines_all
877: Where expenditure_item_id = P_Exp_Item_Id
878: And line_type = 'R');
879:
880: G_exp_item_id := P_Exp_item_Id;

Line 929: From pa_cost_distribution_lines_all

925: g_pa_period_name,
926: g_gl_period_name,
927: g_recvr_pa_period_name,
928: g_recvr_Gl_period_name
929: From pa_cost_distribution_lines_all
930: Where expenditure_item_id = P_Exp_Item_Id
931: And line_type = 'R'
932: And line_num = (
933: Select max(line_num)

Line 934: From pa_cost_distribution_lines_all

930: Where expenditure_item_id = P_Exp_Item_Id
931: And line_type = 'R'
932: And line_num = (
933: Select max(line_num)
934: From pa_cost_distribution_lines_all
935: Where expenditure_item_id = P_Exp_Item_Id
936: And line_type = 'R');
937:
938: G_exp_item_id := P_Exp_item_Id;

Line 987: From pa_cost_distribution_lines_all

983: g_pa_period_name,
984: g_gl_period_name,
985: g_recvr_pa_period_name,
986: g_recvr_gl_period_name
987: From pa_cost_distribution_lines_all
988: Where expenditure_item_id = P_Exp_Item_Id
989: And line_type = 'R'
990: And line_num = (
991: Select max(line_num)

Line 992: From pa_cost_distribution_lines_all

988: Where expenditure_item_id = P_Exp_Item_Id
989: And line_type = 'R'
990: And line_num = (
991: Select max(line_num)
992: From pa_cost_distribution_lines_all
993: Where expenditure_item_id = P_Exp_Item_Id
994: And line_type = 'R');
995:
996: G_exp_item_id := P_Exp_item_Id;