DBA Data[Home] [Help]

APPS.HZ_DQM_MR_PVT dependencies on HZ_PRIMARY_TRANS

Line 587: FROM hz_primary_trans pt, hz_trans_functions_vl f

583: END IF;
584:
585: FIRST := TRUE;
586: FOR trans in ( SELECT staged_attribute_column
587: FROM hz_primary_trans pt, hz_trans_functions_vl f
588: where f.function_id = pt.function_id
589: and pt.primary_attribute_id = attrs.primary_attribute_id
590: )
591: LOOP

Line 635: FROM hz_primary_trans pt, hz_trans_functions_vl f

631: l('and');
632:
633: FIRST := TRUE;
634: FOR trans in ( SELECT staged_attribute_column
635: FROM hz_primary_trans pt, hz_trans_functions_vl f
636: where f.function_id = pt.function_id
637: and pt.primary_attribute_id = attrs.primary_attribute_id
638: )
639: LOOP

Line 710: FROM hz_primary_trans pt, hz_trans_functions_vl f

706: l('and');
707:
708: FIRST := TRUE;
709: FOR trans in ( SELECT staged_attribute_column
710: FROM hz_primary_trans pt, hz_trans_functions_vl f
711: where f.function_id = pt.function_id
712: and pt.primary_attribute_id = attrs.primary_attribute_id
713: )
714: LOOP

Line 875: FROM hz_primary_trans pt, hz_trans_functions_vl f

871: END IF;
872:
873: FIRST := TRUE;
874: FOR trans in ( SELECT staged_attribute_column
875: FROM hz_primary_trans pt, hz_trans_functions_vl f
876: where f.function_id = pt.function_id
877: and pt.primary_attribute_id = attrs.primary_attribute_id
878: )
879: LOOP

Line 923: FROM hz_primary_trans pt, hz_trans_functions_vl f

919:
920:
921: FIRST := TRUE;
922: FOR trans in ( SELECT staged_attribute_column
923: FROM hz_primary_trans pt, hz_trans_functions_vl f
924: where f.function_id = pt.function_id
925: and pt.primary_attribute_id = attrs.primary_attribute_id
926: )
927: LOOP

Line 1416: FROM hz_primary_trans pt, hz_trans_functions_vl f

1412: END IF;
1413:
1414: FIRST := TRUE;
1415: FOR trans in ( SELECT staged_attribute_column
1416: FROM hz_primary_trans pt, hz_trans_functions_vl f
1417: where f.function_id = pt.function_id
1418: and pt.primary_attribute_id = attrs.primary_attribute_id
1419: )
1420: LOOP

Line 1467: FROM hz_primary_trans pt, hz_trans_functions_vl f

1463: l('and ');
1464:
1465: FIRST := TRUE;
1466: FOR trans in ( SELECT staged_attribute_column
1467: FROM hz_primary_trans pt, hz_trans_functions_vl f
1468: where f.function_id = pt.function_id
1469: and pt.primary_attribute_id = attrs.primary_attribute_id
1470: )
1471: LOOP

Line 1622: FROM hz_primary_trans pt, hz_trans_functions_vl f

1618: END IF;
1619:
1620: FIRST := TRUE;
1621: FOR trans in ( SELECT staged_attribute_column
1622: FROM hz_primary_trans pt, hz_trans_functions_vl f
1623: where f.function_id = pt.function_id
1624: and pt.primary_attribute_id = attrs.primary_attribute_id
1625: )
1626: LOOP

Line 1670: FROM hz_primary_trans pt, hz_trans_functions_vl f

1666: l('and ');
1667:
1668: FIRST := TRUE;
1669: FOR trans in ( SELECT staged_attribute_column
1670: FROM hz_primary_trans pt, hz_trans_functions_vl f
1671: where f.function_id = pt.function_id
1672: and pt.primary_attribute_id = attrs.primary_attribute_id
1673: )
1674: LOOP

Line 1757: FROM hz_primary_trans pt, hz_trans_functions_vl f

1753: l('and');
1754:
1755: FIRST := TRUE;
1756: FOR trans in ( SELECT staged_attribute_column
1757: FROM hz_primary_trans pt, hz_trans_functions_vl f
1758: where f.function_id = pt.function_id
1759: and pt.primary_attribute_id = attrs.primary_attribute_id
1760: )
1761: LOOP

Line 1914: FROM hz_primary_trans pt, hz_trans_functions_vl f

1910: END IF;
1911:
1912: FIRST := TRUE;
1913: FOR trans in ( SELECT staged_attribute_column
1914: FROM hz_primary_trans pt, hz_trans_functions_vl f
1915: where f.function_id = pt.function_id
1916: and pt.primary_attribute_id = attrs.primary_attribute_id
1917: )
1918: LOOP

Line 1962: FROM hz_primary_trans pt, hz_trans_functions_vl f

1958: l('and ');
1959:
1960: FIRST := TRUE;
1961: FOR trans in ( SELECT staged_attribute_column
1962: FROM hz_primary_trans pt, hz_trans_functions_vl f
1963: where f.function_id = pt.function_id
1964: and pt.primary_attribute_id = attrs.primary_attribute_id
1965: )
1966: LOOP

Line 2507: FROM hz_primary_trans pt, hz_trans_functions_vl f

2503: END IF;
2504:
2505: FIRST := TRUE;
2506: FOR trans in ( SELECT staged_attribute_column
2507: FROM hz_primary_trans pt, hz_trans_functions_vl f
2508: where f.function_id = pt.function_id
2509: and pt.primary_attribute_id = attrs.primary_attribute_id
2510: )
2511: LOOP

Line 2558: FROM hz_primary_trans pt, hz_trans_functions_vl f

2554: l('and ');
2555:
2556: FIRST := TRUE;
2557: FOR trans in ( SELECT staged_attribute_column
2558: FROM hz_primary_trans pt, hz_trans_functions_vl f
2559: where f.function_id = pt.function_id
2560: and pt.primary_attribute_id = attrs.primary_attribute_id
2561: )
2562: LOOP

Line 2721: FROM hz_primary_trans pt, hz_trans_functions_vl f

2717: END IF;
2718:
2719: FIRST := TRUE;
2720: FOR trans in ( SELECT staged_attribute_column
2721: FROM hz_primary_trans pt, hz_trans_functions_vl f
2722: where f.function_id = pt.function_id
2723: and pt.primary_attribute_id = attrs.primary_attribute_id
2724: )
2725: LOOP

Line 2769: FROM hz_primary_trans pt, hz_trans_functions_vl f

2765: l('and ');
2766:
2767: FIRST := TRUE;
2768: FOR trans in ( SELECT staged_attribute_column
2769: FROM hz_primary_trans pt, hz_trans_functions_vl f
2770: where f.function_id = pt.function_id
2771: and pt.primary_attribute_id = attrs.primary_attribute_id
2772: )
2773: LOOP

Line 2844: FROM hz_primary_trans pt, hz_trans_functions_vl f

2840: l('and');
2841:
2842: FIRST := TRUE;
2843: FOR trans in ( SELECT staged_attribute_column
2844: FROM hz_primary_trans pt, hz_trans_functions_vl f
2845: where f.function_id = pt.function_id
2846: and pt.primary_attribute_id = attrs.primary_attribute_id
2847: )
2848: LOOP

Line 3010: FROM hz_primary_trans pt, hz_trans_functions_vl f

3006: END IF;
3007:
3008: FIRST := TRUE;
3009: FOR trans in ( SELECT staged_attribute_column
3010: FROM hz_primary_trans pt, hz_trans_functions_vl f
3011: where f.function_id = pt.function_id
3012: and pt.primary_attribute_id = attrs.primary_attribute_id
3013: )
3014: LOOP

Line 3056: FROM hz_primary_trans pt, hz_trans_functions_vl f

3052: l('and ');
3053:
3054: FIRST := TRUE;
3055: FOR trans in ( SELECT staged_attribute_column
3056: FROM hz_primary_trans pt, hz_trans_functions_vl f
3057: where f.function_id = pt.function_id
3058: and pt.primary_attribute_id = attrs.primary_attribute_id
3059: )
3060: LOOP