DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_PROJECT_TYPES

Line 1212: FROM pa_project_types ppt,

1208: SELECT decode(NVL(ppt.burden_cost_flag, 'N'),'Y',
1209: NVL(ppt.burden_amt_display_method,'S'),'N')
1210: -- decode(NVL(ppt.burden_amt_display_method,'S'), 'S','SAME','D','DIFFERENT'),'NONE')
1211: INTO l_burden_method
1212: FROM pa_project_types ppt,
1213: pa_projects_all pp
1214: WHERE
1215: ppt.project_type = pp.project_type
1216: AND pp.project_id = p_project_id;

Line 7582: ,pa_project_types_all pt

7578: ,pkt.resource_list_member_id
7579: ,decode(NVL(pt.burden_amt_display_method,'N'),'D'
7580: ,decode(parent_bc_packet_id,NULL,'RAW','BURDEN'),'RAW') pkt_line_type
7581: FROM pa_bc_packets pkt
7582: ,pa_project_types_all pt
7583: ,pa_projects_all pp
7584: WHERE pkt.packet_id = p_packet_id
7585: AND pkt.document_line_id is not null
7586: AND pkt.document_type in ('PO','EXP')