DBA Data[Home] [Help]

APPS.PSP_AUTOPOP dependencies on PSP_AUTO_ACCTS

Line 606: FROM psp_auto_accts a

602:
603: CURSOR exp_accts_c(p_period_type in VARCHAR2) IS
604: SELECT acct_id, expenditure_type,
605: acct_seq_num --added for debug purposes
606: FROM psp_auto_accts a
607: WHERE acct_type = 'E'
608: AND period_type = p_period_type
609: AND p_payroll_date BETWEEN start_date_active AND NVL(end_date_active, p_payroll_date)
610: AND business_group_id=p_business_group_id

Line 619: FROM psp_auto_accts a

615:
616: CURSOR na_accts_c(p_period_type in VARCHAR2) IS
617: SELECT acct_id,segment_num, natural_account,
618: acct_seq_num --added for debug purposes
619: FROM psp_auto_accts a
620: WHERE acct_type = 'N'
621: AND period_type = p_period_type
622: AND segment_num = l_segment_num
623: and business_group_id=p_business_group_id