DBA Data[Home] [Help]

APPS.PSP_PAYTRN dependencies on PAY_ACTION_PARAMETER_VALUES

Line 96: from PAY_ACTION_PARAMETER_VALUES

92: --- modified the below 2 cursors for bug 6661707
93:
94: cursor get_tgl_date_used is
95: select nvl(parameter_value, 'P') parameter_value
96: from PAY_ACTION_PARAMETER_VALUES
97: where parameter_name = 'TGL_DATE_USED'
98: and action_parameter_group_id = l_action_parameter_group;
99:
100: cursor get_tgl_revb_acc_date is

Line 102: from PAY_ACTION_PARAMETER_VALUES

98: and action_parameter_group_id = l_action_parameter_group;
99:
100: cursor get_tgl_revb_acc_date is
101: select nvl(parameter_value, 'P') parameter_value
102: from PAY_ACTION_PARAMETER_VALUES
103: where parameter_name = 'TGL_REVB_ACC_DATE'
104: and action_parameter_group_id = l_action_parameter_group;
105:
106: /* to select all costed record for quickpay/ regular pay for a particular timeperiod . This would replace both the