DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_PKG dependencies on PA_PROJECT_TYPES

Line 1216: FROM pa_project_types ppt,

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

Line 7780: ,pa_project_types_all pt

7776: ,pkt.resource_list_member_id
7777: ,decode(NVL(pt.burden_amt_display_method,'N'),'D'
7778: ,decode(parent_bc_packet_id,NULL,'RAW','BURDEN'),'RAW') pkt_line_type
7779: FROM pa_bc_packets pkt
7780: ,pa_project_types_all pt
7781: ,pa_projects_all pp
7782: WHERE pkt.packet_id = p_packet_id
7783: AND pkt.document_line_id is not null
7784: AND pkt.document_type in ('PO','EXP')