APPS.PAY_CA_DIRECT_DEPOSIT_PKG dependencies on PAY_CA_LEGISLATION_INFO

Line 34: from pay_ca_legislation_info

30: -- Financial Institution.
31: --
32: CURSOR get_num_fcns_allowed(p_fin_institution varchar2) IS
33: select information_value
34: from pay_ca_legislation_info
35: where information_type = 'CA_DD_FCN_ROWS'
36: and lookup_code = p_fin_institution;
37: --
38: -- Cursor to count number of rows currently in FCN table for a given Originator

Line 69: from pay_ca_legislation_info

65: -- Cursor to find the test FCN for a given Financial Institution
66: --
67: CURSOR get_test_fcn(p_fin_institution varchar2) IS
68: select information_value
69: from pay_ca_legislation_info
70: where information_type = 'CA_DD_TEST'
71: and lookup_code = p_fin_institution;
72: --
73: -- Cursor to find the next FCN for a given Originator ID and seqence number

Line 531: from pay_ca_legislation_info

527: -- for a particular Financial Institution.
528: --
529: CURSOR get_num_fcns_allowed(cp_fin_institution varchar2) IS
530: select TO_NUMBER(information_value)
531: from pay_ca_legislation_info
532: where information_type = 'CA_DD_FCN_ROWS'
533: and lookup_code = cp_fin_institution;
534:
535:

Line 597: from pay_ca_legislation_info

593:
594: -- Cursor to check whether the Override FCN is a test FCN or not
595: CURSOR get_test_fcn(p_fin_institution varchar2) IS
596: select information_value
597: from pay_ca_legislation_info
598: where information_type = 'CA_DD_TEST'
599: and lookup_code = p_fin_institution;
600:
601: -- Procedure to stamp the FCN number in pay_payroll_actions table