APPS.PA_PAY_INTERFACE dependencies on PA_PAY_REJECTION_ID_S

Line 1088: PA_PAY_REJECTION_ID_S.NEXTVAL,

1084: CREATION_DATE ,
1085: CREATED_BY
1086: )
1087: SELECT
1088: PA_PAY_REJECTION_ID_S.NEXTVAL,
1089: INTERFACE_RUN_ID ,
1090: PERSON_ID ,
1091: ASSIGNMENT_ID ,
1092: Pay_source_id ,

Line 1126: PA_PAY_REJECTION_ID_S.NEXTVAL,

1122: CREATION_DATE ,
1123: CREATED_BY
1124: )
1125: SELECT
1126: PA_PAY_REJECTION_ID_S.NEXTVAL,
1127: INTERFACE_RUN_ID ,
1128: PERSON_ID ,
1129: ASSIGNMENT_ID ,
1130: PAY_SOURCE_ID ,

Line 1168: PA_PAY_REJECTION_ID_S.NEXTVAL,

1164: CREATION_DATE ,
1165: CREATED_BY
1166: )
1167: SELECT
1168: PA_PAY_REJECTION_ID_S.NEXTVAL,
1169: PPS.INTERFACE_RUN_ID ,
1170: PERSON_ID ,
1171: ASSIGNMENT_ID ,
1172: Pay_source_id ,

Line 1209: PA_PAY_REJECTION_ID_S.NEXTVAL,

1205: CREATION_DATE ,
1206: CREATED_BY
1207: )
1208: SELECT
1209: PA_PAY_REJECTION_ID_S.NEXTVAL,
1210: INTERFACE_RUN_ID ,
1211: PERSON_ID ,
1212: ASSIGNMENT_ID ,
1213: Pay_source_id ,

Line 1282: PA_PAY_REJECTION_ID_S.NEXTVAL,

1278: CREATION_DATE ,
1279: CREATED_BY
1280: )
1281: SELECT
1282: PA_PAY_REJECTION_ID_S.NEXTVAL,
1283: INTERFACE_RUN_ID ,
1284: PERSON_ID ,
1285: ASSIGNMENT_ID ,
1286: PAY_SOURCE_ID ,

Line 1349: PA_PAY_REJECTION_ID_S.NEXTVAL,

1345: CREATION_DATE ,
1346: CREATED_BY
1347: )
1348: SELECT
1349: PA_PAY_REJECTION_ID_S.NEXTVAL,
1350: INTERFACE_RUN_ID ,
1351: PERSON_ID ,
1352: ASSIGNMENT_ID ,
1353: Pay_source_id ,

Line 1414: PA_PAY_REJECTION_ID_S.NEXTVAL,

1410: CREATION_DATE ,
1411: CREATED_BY
1412: )
1413: SELECT
1414: PA_PAY_REJECTION_ID_S.NEXTVAL,
1415: INTERFACE_RUN_ID ,
1416: PERSON_ID ,
1417: ASSIGNMENT_ID ,
1418: PAY_SOURCE_ID ,

Line 1478: PA_PAY_REJECTION_ID_S.NEXTVAL,

1474: CREATION_DATE ,
1475: CREATED_BY
1476: )
1477: SELECT
1478: PA_PAY_REJECTION_ID_S.NEXTVAL,
1479: INTERFACE_RUN_ID ,
1480: PERSON_ID ,
1481: ASSIGNMENT_ID ,
1482: PAY_SOURCE_ID ,

Line 2146: PA_PAY_REJECTION_ID_S.nextval,

2142: CREATION_DATE ,
2143: CREATED_BY
2144: )
2145: SELECT
2146: PA_PAY_REJECTION_ID_S.nextval,
2147: G_INTERFACE_RUN_ID ,
2148: PS.PERSON_ID ,
2149: PS.ASSIGNMENT_ID ,
2150: PS.PAY_SOURCE_ID ,

Line 2331: SELECT PA_PAY_REJECTION_ID_S.NEXTVAL,

2327: LAST_UPDATED_BY ,
2328: CREATION_DATE ,
2329: CREATED_BY
2330: )
2331: SELECT PA_PAY_REJECTION_ID_S.NEXTVAL,
2332: G_INTERFACE_RUN_ID ,
2333: PS.PERSON_ID ,
2334: PS.ASSIGNMENT_ID ,
2335: PS.PAY_SOURCE_ID ,

Line 2645: SELECT PA_PAY_REJECTION_ID_S.NEXTVAL

2641: , LAST_UPDATED_BY
2642: , CREATION_DATE
2643: , CREATED_BY
2644: )
2645: SELECT PA_PAY_REJECTION_ID_S.NEXTVAL
2646: , G_INTERFACE_RUN_ID
2647: , PS.PERSON_ID
2648: , PS.ASSIGNMENT_ID
2649: , PS.PAY_SOURCE_ID

Line 2863: SELECT PA_PAY_REJECTION_ID_S.NEXTVAL

2859: , LAST_UPDATED_BY
2860: , CREATION_DATE
2861: , CREATED_BY
2862: )
2863: SELECT PA_PAY_REJECTION_ID_S.NEXTVAL
2864: , G_INTERFACE_RUN_ID
2865: , PS.PERSON_ID
2866: , PS.ASSIGNMENT_ID
2867: , PS.PAY_SOURCE_ID

Line 3071: SELECT PA_PAY_REJECTION_ID_S.NEXTVAL

3067: , LAST_UPDATED_BY
3068: , CREATION_DATE
3069: , CREATED_BY
3070: )
3071: SELECT PA_PAY_REJECTION_ID_S.NEXTVAL
3072: , G_INTERFACE_RUN_ID
3073: , PS.PERSON_ID
3074: , PS.ASSIGNMENT_ID
3075: , PS.PAY_SOURCE_ID

Line 3576: PA_PAY_REJECTION_ID_S.nextval,

3572: CREATED_BY
3573: )
3574: VALUES
3575: (
3576: PA_PAY_REJECTION_ID_S.nextval,
3577: G_INTERFACE_RUN_ID ,
3578: G_PERSON_ID ,
3579: G_ASSIGNMENT_ID ,
3580: P_PAY_SOURCE_ID ,

Line 3632: select PA_PAY_REJECTION_ID_S.nextval,

3628: LAST_UPDATED_BY ,
3629: CREATION_DATE ,
3630: CREATED_BY
3631: )
3632: select PA_PAY_REJECTION_ID_S.nextval,
3633: INTERFACE_RUN_ID ,
3634: PERSON_ID ,
3635: ASSIGNMENT_ID ,
3636: P_PAY_SOURCE_ID ,

Line 3709: PA_PAY_REJECTION_ID_S.NEXTVAL,

3705: CREATION_DATE ,
3706: CREATED_BY
3707: )
3708: SELECT
3709: PA_PAY_REJECTION_ID_S.NEXTVAL,
3710: G_INTERFACE_RUN_ID ,
3711: PERSON_ID ,
3712: ASSIGNMENT_ID ,
3713: PAY_SOURCE_ID ,

Line 3784: PA_PAY_REJECTION_ID_S.NEXTVAL, rej.*

3780: CREATION_DATE ,
3781: CREATED_BY
3782: )
3783: SELECT
3784: PA_PAY_REJECTION_ID_S.NEXTVAL, rej.*
3785: from
3786: (select DISTINCT
3787: G_INTERFACE_RUN_ID INTERFACE_RUN_ID,
3788: G_PERSON_ID PERSON_ID,

Line 3845: PA_PAY_REJECTION_ID_S.NEXTVAL, rej.*

3841: CREATION_DATE ,
3842: CREATED_BY
3843: )
3844: SELECT
3845: PA_PAY_REJECTION_ID_S.NEXTVAL, rej.*
3846: from
3847: (select DISTINCT
3848: G_INTERFACE_RUN_ID INTERFACE_RUN_ID,
3849: G_PERSON_ID PERSON_ID,