DBA Data[Home] [Help]

APPS.PA_TXN_ACCUMS dependencies on PA_COMMITMENT_TXNS_S

Line 22: pa_commitment_txns_s.NEXTVAL

18: FUNCTION cmt_line_id RETURN NUMBER IS
19: cmt_line_id NUMBER;
20: BEGIN
21: SELECT
22: pa_commitment_txns_s.NEXTVAL
23: INTO cmt_line_id
24: FROM
25: SYS.DUAL;
26: RETURN cmt_line_id;

Line 2038: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,

2034: BOM_EQUIPMENT_RESOURCE_ID,
2035: RESOURCE_CLASS
2036: )
2037: select /*+ push_pred(pctv) */
2038: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,
2039: pctv.PROJECT_ID,
2040: pctv.TASK_ID,
2041: pctv.TRANSACTION_SOURCE,
2042: decode(pctv.LINE_TYPE,

Line 2291: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,

2287: BOM_EQUIPMENT_RESOURCE_ID,
2288: RESOURCE_CLASS
2289: )
2290: select
2291: PA_COMMITMENT_TXNS_S.NEXTVAL CMT_LINE_ID,
2292: pctv.PROJECT_ID,
2293: pctv.TASK_ID,
2294: pctv.TRANSACTION_SOURCE,
2295: pctv.LINE_TYPE,