DBA Data[Home] [Help]

APPS.PSP_PSPARREP_XMLP_PKG dependencies on PAY_PAYROLLS_F

Line 123: PAY_PAYROLLS_F PPF

119: CURSOR c_distribution IS
120: SELECT COUNT(*) no_dist_lines
121: FROM PSP_PAYROLL_CONTROLS PPC,
122: PER_TIME_PERIODS PTP,
123: PAY_PAYROLLS_F PPF
124: WHERE PPC.payroll_id = PPF.payroll_id
125: and PPC.time_period_id = PTP.time_period_id
126: and PPC.payroll_id = nvl(p_payroll_id,PPF.payroll_id)
127: and PTP.time_period_id >= nvl(p_begin_period,PTP.time_period_id)

Line 137: PAY_PAYROLLS_F PPF

133: CURSOR c_encumbrance IS
134: SELECT COUNT(*) no_enc_lines
135: FROM PSP_ENC_CONTROLS PEC,
136: PER_TIME_PERIODS PTP,
137: PAY_PAYROLLS_F PPF
138: WHERE PEC.payroll_id = PPF.payroll_id
139: and PEC.time_period_id = PTP.time_period_id
140: and PEC.payroll_id = nvl(p_payroll_id,PPF.payroll_id)
141: and PTP.time_period_id >= nvl(p_begin_period,PTP.time_period_id)