DBA Data[Home] [Help]

APPS.PER_ZA_UTILITY_PKG dependencies on PAY_ACTION_CONTEXTS

Line 980: INSERT INTO pay_action_contexts

976: ,cur_run_res_con_rec.element_entry_id
977: ,l_Dir_no);
978:
979: if l_Dir_no is not null then
980: INSERT INTO pay_action_contexts
981: (assignment_action_id
982: ,assignment_id
983: ,context_id
984: ,context_value)

Line 991: from pay_action_contexts

987: ,l_Dir_no_con
988: ,l_dir_no
989: from dual
990: where not exists (select null
991: from pay_action_contexts
992: where assignment_action_id = cur_run_res_con_rec.assignment_action_id
993: and assignment_id = cur_run_res_con_rec.assignment_id
994: and context_id = l_Dir_no_con
995: and context_value = l_dir_no )

Line 1006: INSERT INTO pay_action_contexts

1002: ,cur_run_res_con_rec.element_entry_id
1003: ,l_clar_no);
1004:
1005: if l_clar_no is not null then
1006: INSERT INTO pay_action_contexts
1007: (assignment_action_id
1008: ,assignment_id
1009: ,context_id
1010: ,context_value)

Line 1017: from pay_action_contexts

1013: ,l_clar_no_con
1014: ,l_clar_no
1015: from dual
1016: where not exists (select null
1017: from pay_action_contexts
1018: where assignment_action_id = cur_run_res_con_rec.assignment_action_id
1019: and assignment_id = cur_run_res_con_rec.assignment_id
1020: and context_id = l_clar_no_con
1021: and context_value = l_clar_no )