DBA Data[Home] [Help]

APPS.PAY_BALANCE_UPLOAD dependencies on PER_JOBS

Line 2076: l_assignment_job_name per_jobs.name%type;

2072: p_message out nocopy varchar2
2073: ) is
2074:
2075: l_reporting_unit_id number := 0;
2076: l_assignment_job_name per_jobs.name%type;
2077: l_jur_code fnd_lookup_values.lookup_code%type;
2078: l_formula_id ff_formulas_f.formula_id%type;
2079: l_wcb_acc_number pay_element_entry_values_f.screen_entry_value%type := null;
2080: l_wcb_rate_code pay_element_entry_values_f.screen_entry_value%type := null;

Line 2151: from per_jobs JOB

2147:
2148: CURSOR C_ASSIGNMENT_JOB
2149: IS
2150: select JOB.name
2151: from per_jobs JOB
2152: , per_all_assignments_f ASSIGN
2153: where p_effective_date BETWEEN ASSIGN.effective_start_date
2154: AND ASSIGN.effective_end_date
2155: and ASSIGN.assignment_id = p_asg_id