DBA Data[Home] [Help]

APPS.PAY_AU_RECON_SUMMARY dependencies on PAY_BALANCE_PKG

Line 59: g_input_table pay_balance_pkg.t_balance_value_tab;

55: /* End bug 3034189 */
56:
57: /*------- Bug# 3193479 ---------------------------------------------------------------*/
58:
59: g_input_table pay_balance_pkg.t_balance_value_tab;
60: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
61: g_context_table pay_balance_pkg.t_context_tab;
62: /* Start of Bug : 3186840*/
63:

Line 60: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;

56:
57: /*------- Bug# 3193479 ---------------------------------------------------------------*/
58:
59: g_input_table pay_balance_pkg.t_balance_value_tab;
60: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
61: g_context_table pay_balance_pkg.t_context_tab;
62: /* Start of Bug : 3186840*/
63:
64: /* Changes for 9147438 start */

Line 61: g_context_table pay_balance_pkg.t_context_tab;

57: /*------- Bug# 3193479 ---------------------------------------------------------------*/
58:
59: g_input_table pay_balance_pkg.t_balance_value_tab;
60: g_result_table pay_balance_pkg.t_detailed_bal_out_tab;
61: g_context_table pay_balance_pkg.t_context_tab;
62: /* Start of Bug : 3186840*/
63:
64: /* Changes for 9147438 start */
65: g_fw_input_table pay_au_foreign_workers.tab_bal_type;

Line 66: g_fw_result_table pay_balance_pkg.t_detailed_bal_out_tab;

62: /* Start of Bug : 3186840*/
63:
64: /* Changes for 9147438 start */
65: g_fw_input_table pay_au_foreign_workers.tab_bal_type;
66: g_fw_result_table pay_balance_pkg.t_detailed_bal_out_tab;
67: g_fw_context_table pay_balance_pkg.t_context_tab;
68: g_fw_input_alw_table pay_au_foreign_workers.tab_bal_type;
69: g_fw_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
70: g_fw_allowance_tab pay_au_payment_summary.t_allowance_balance%type;

Line 67: g_fw_context_table pay_balance_pkg.t_context_tab;

63:
64: /* Changes for 9147438 start */
65: g_fw_input_table pay_au_foreign_workers.tab_bal_type;
66: g_fw_result_table pay_balance_pkg.t_detailed_bal_out_tab;
67: g_fw_context_table pay_balance_pkg.t_context_tab;
68: g_fw_input_alw_table pay_au_foreign_workers.tab_bal_type;
69: g_fw_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
70: g_fw_allowance_tab pay_au_payment_summary.t_allowance_balance%type;
71:

Line 69: g_fw_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;

65: g_fw_input_table pay_au_foreign_workers.tab_bal_type;
66: g_fw_result_table pay_balance_pkg.t_detailed_bal_out_tab;
67: g_fw_context_table pay_balance_pkg.t_context_tab;
68: g_fw_input_alw_table pay_au_foreign_workers.tab_bal_type;
69: g_fw_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
70: g_fw_allowance_tab pay_au_payment_summary.t_allowance_balance%type;
71:
72: type r_allowance_bal is record (balance_name pay_balance_types.balance_name%type, balance_value number);
73: type tab_allownace_balance is table of r_allowance_bal index by binary_integer;

Line 77: g_input_term_details_table pay_balance_pkg.t_balance_value_tab;

73: type tab_allownace_balance is table of r_allowance_bal index by binary_integer;
74: p_fw_allowance_tab tab_allownace_balance;
75: /* Changes for 9147438 end */
76:
77: g_input_term_details_table pay_balance_pkg.t_balance_value_tab;
78: g_result_term_details_table pay_balance_pkg.t_detailed_bal_out_tab;
79:
80: g_input_group_details_table pay_balance_pkg.t_balance_value_tab;
81: g_result_group_details_table pay_balance_pkg.t_detailed_bal_out_tab;

Line 78: g_result_term_details_table pay_balance_pkg.t_detailed_bal_out_tab;

74: p_fw_allowance_tab tab_allownace_balance;
75: /* Changes for 9147438 end */
76:
77: g_input_term_details_table pay_balance_pkg.t_balance_value_tab;
78: g_result_term_details_table pay_balance_pkg.t_detailed_bal_out_tab;
79:
80: g_input_group_details_table pay_balance_pkg.t_balance_value_tab;
81: g_result_group_details_table pay_balance_pkg.t_detailed_bal_out_tab;
82:

Line 80: g_input_group_details_table pay_balance_pkg.t_balance_value_tab;

76:
77: g_input_term_details_table pay_balance_pkg.t_balance_value_tab;
78: g_result_term_details_table pay_balance_pkg.t_detailed_bal_out_tab;
79:
80: g_input_group_details_table pay_balance_pkg.t_balance_value_tab;
81: g_result_group_details_table pay_balance_pkg.t_detailed_bal_out_tab;
82:
83: g_input_fw_grp_dtls_table pay_au_foreign_workers.tab_bal_type;
84: g_result_fw_grp_dtls_table pay_balance_pkg.t_detailed_bal_out_tab;

Line 81: g_result_group_details_table pay_balance_pkg.t_detailed_bal_out_tab;

77: g_input_term_details_table pay_balance_pkg.t_balance_value_tab;
78: g_result_term_details_table pay_balance_pkg.t_detailed_bal_out_tab;
79:
80: g_input_group_details_table pay_balance_pkg.t_balance_value_tab;
81: g_result_group_details_table pay_balance_pkg.t_detailed_bal_out_tab;
82:
83: g_input_fw_grp_dtls_table pay_au_foreign_workers.tab_bal_type;
84: g_result_fw_grp_dtls_table pay_balance_pkg.t_detailed_bal_out_tab;
85:

Line 84: g_result_fw_grp_dtls_table pay_balance_pkg.t_detailed_bal_out_tab;

80: g_input_group_details_table pay_balance_pkg.t_balance_value_tab;
81: g_result_group_details_table pay_balance_pkg.t_detailed_bal_out_tab;
82:
83: g_input_fw_grp_dtls_table pay_au_foreign_workers.tab_bal_type;
84: g_result_fw_grp_dtls_table pay_balance_pkg.t_detailed_bal_out_tab;
85:
86:
87: g_input_grp_assgt_dets_table pay_balance_pkg.t_balance_value_tab;
88: g_result_grp_assgt_dets_table pay_balance_pkg.t_detailed_bal_out_tab;

Line 87: g_input_grp_assgt_dets_table pay_balance_pkg.t_balance_value_tab;

83: g_input_fw_grp_dtls_table pay_au_foreign_workers.tab_bal_type;
84: g_result_fw_grp_dtls_table pay_balance_pkg.t_detailed_bal_out_tab;
85:
86:
87: g_input_grp_assgt_dets_table pay_balance_pkg.t_balance_value_tab;
88: g_result_grp_assgt_dets_table pay_balance_pkg.t_detailed_bal_out_tab;
89:
90:
91: g_bal_dim_level varchar2(1);

Line 88: g_result_grp_assgt_dets_table pay_balance_pkg.t_detailed_bal_out_tab;

84: g_result_fw_grp_dtls_table pay_balance_pkg.t_detailed_bal_out_tab;
85:
86:
87: g_input_grp_assgt_dets_table pay_balance_pkg.t_balance_value_tab;
88: g_result_grp_assgt_dets_table pay_balance_pkg.t_detailed_bal_out_tab;
89:
90:
91: g_bal_dim_level varchar2(1);
92: g_dimension_name pay_balance_dimensions.dimension_name%TYPE;

Line 97: g_input_alw_table pay_balance_pkg.t_balance_value_tab;

93:
94: /* End of Bug : 3186840 */
95:
96: /* start bug 7571001 */
97: g_input_alw_table pay_balance_pkg.t_balance_value_tab;
98: g_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
99:
100: g_input_group_alw_table pay_balance_pkg.t_balance_value_tab;
101: g_result_group_alw_table pay_balance_pkg.t_detailed_bal_out_tab;

Line 98: g_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;

94: /* End of Bug : 3186840 */
95:
96: /* start bug 7571001 */
97: g_input_alw_table pay_balance_pkg.t_balance_value_tab;
98: g_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
99:
100: g_input_group_alw_table pay_balance_pkg.t_balance_value_tab;
101: g_result_group_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
102: /* end bug 7571001 */

Line 100: g_input_group_alw_table pay_balance_pkg.t_balance_value_tab;

96: /* start bug 7571001 */
97: g_input_alw_table pay_balance_pkg.t_balance_value_tab;
98: g_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
99:
100: g_input_group_alw_table pay_balance_pkg.t_balance_value_tab;
101: g_result_group_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
102: /* end bug 7571001 */
103:
104: TYPE

Line 101: g_result_group_alw_table pay_balance_pkg.t_detailed_bal_out_tab;

97: g_input_alw_table pay_balance_pkg.t_balance_value_tab;
98: g_result_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
99:
100: g_input_group_alw_table pay_balance_pkg.t_balance_value_tab;
101: g_result_group_alw_table pay_balance_pkg.t_detailed_bal_out_tab;
102: /* end bug 7571001 */
103:
104: TYPE
105: g_bal_type_tab IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER; /*Bug#4863149*/