DBA Data[Home] [Help]

APPS.PAY_CA_T4_XML dependencies on PAY_CA_LEGISLATION_INFO

Line 664: from pay_ca_legislation_info

660: l_is_temp_final_xml VARCHAR2(2);
661:
662: cursor cur_max_cpp_earning is
663: select information_value
664: from pay_ca_legislation_info
665: where information_type = 'MAX_CPP_EARNINGS'
666: and to_date(lv_year ||'/01/01','YYYY/MM/DD')
667: between start_date and end_date;
668:

Line 671: from pay_ca_legislation_info

667: between start_date and end_date;
668:
669: cursor cur_max_ei_earning is
670: select information_value
671: from pay_ca_legislation_info
672: where information_type = 'MAX_EI_EARNINGS'
673: and to_date(lv_year ||'/01/01','YYYY/MM/DD')
674: between start_date and end_date;
675:

Line 678: from pay_ca_legislation_info

674: between start_date and end_date;
675:
676: cursor cur_max_ppip_earning is
677: select information_value
678: from pay_ca_legislation_info
679: where information_type = 'MAX_PPIP_EARNINGS'
680: and to_date(lv_year ||'/01/01','YYYY/MM/DD')
681: between start_date and end_date;
682: