DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PAY_BALANCE_CONTEXT_VALUES

Line 3557: insert into pay_balance_context_values

3553: open csr_get_context_id('TAX_UNIT_ID');
3554: fetch csr_get_context_id into ctx_id;
3555: close csr_get_context_id;
3556: --
3557: insert into pay_balance_context_values
3558: (latest_balance_id,
3559: context_id,
3560: value)
3561: values (l_lat_bal_id,

Line 3573: insert into pay_balance_context_values

3569: open csr_get_context_id('JURISDICTION_CODE');
3570: fetch csr_get_context_id into ctx_id;
3571: close csr_get_context_id;
3572: --
3573: insert into pay_balance_context_values
3574: (latest_balance_id,
3575: context_id,
3576: value)
3577: values (l_lat_bal_id,

Line 3588: insert into pay_balance_context_values

3584: open csr_get_context_id('ORIGINAL_ENTRY_ID');
3585: fetch csr_get_context_id into ctx_id;
3586: close csr_get_context_id;
3587: --
3588: insert into pay_balance_context_values
3589: (latest_balance_id,
3590: context_id,
3591: value)
3592: values (l_lat_bal_id,

Line 3605: insert into pay_balance_context_values

3601: open csr_get_context_id('SOURCE_ID');
3602: fetch csr_get_context_id into ctx_id;
3603: close csr_get_context_id;
3604: --
3605: insert into pay_balance_context_values
3606: (latest_balance_id,
3607: context_id,
3608: value)
3609: values (l_lat_bal_id,

Line 3621: insert into pay_balance_context_values

3617: open csr_get_context_id('SOURCE_TEXT');
3618: fetch csr_get_context_id into ctx_id;
3619: close csr_get_context_id;
3620: --
3621: insert into pay_balance_context_values
3622: (latest_balance_id,
3623: context_id,
3624: value)
3625: values (l_lat_bal_id,

Line 3637: insert into pay_balance_context_values

3633: open csr_get_context_id('SOURCE_NUMBER');
3634: fetch csr_get_context_id into ctx_id;
3635: close csr_get_context_id;
3636: --
3637: insert into pay_balance_context_values
3638: (latest_balance_id,
3639: context_id,
3640: value)
3641: values (l_lat_bal_id,

Line 3653: insert into pay_balance_context_values

3649: open csr_get_context_id('SOURCE_TEXT2');
3650: fetch csr_get_context_id into ctx_id;
3651: close csr_get_context_id;
3652: --
3653: insert into pay_balance_context_values
3654: (latest_balance_id,
3655: context_id,
3656: value)
3657: values (l_lat_bal_id,