APPS.PAY_INTERPRETER_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 3485: p_assignment_id IN per_all_assignments_f.assignment_id%type,

3481: (
3482: p_element_entry_id IN pay_element_entries.element_entry_id%type,
3483: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
3484: p_business_group_id IN per_business_groups.business_group_id%type,
3485: p_assignment_id IN per_all_assignments_f.assignment_id%type,
3486: p_mode IN VARCHAR2,
3487: p_process IN VARCHAR2,
3488: p_process_mode IN VARCHAR2,
3489: p_event_group_id IN pay_event_groups.event_group_id%type,

Line 3674: p_assignment_id IN per_all_assignments_f.assignment_id%type,

3670: (
3671: p_element_entry_id IN pay_element_entries.element_entry_id%type,
3672: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
3673: p_business_group_id IN per_business_groups.business_group_id%type,
3674: p_assignment_id IN per_all_assignments_f.assignment_id%type,
3675: p_process_mode IN VARCHAR2,
3676: p_event_group_id IN pay_event_groups.event_group_id%type,
3677: p_start_date IN date,
3678: p_end_date IN date,

Line 4225: p_assignment_id IN per_all_assignments_f.assignment_id%type,

4221: (
4222: p_element_entry_id IN pay_element_entries.element_entry_id%type,
4223: p_assignment_action_id IN pay_assignment_actions.assignment_action_id%type,
4224: p_business_group_id IN per_business_groups.business_group_id%type,
4225: p_assignment_id IN per_all_assignments_f.assignment_id%type,
4226: p_process_mode IN VARCHAR2,
4227: p_event_group_id IN pay_event_groups.event_group_id%type,
4228: p_start_date IN date,
4229: p_end_date IN date,

Line 4795: per_all_assignments_f paf

4791: is
4792: select /*+ USE_NL(pgr paf)*/
4793: pgr.grade_rule_id
4794: from pay_grade_rules_f pgr,
4795: per_all_assignments_f paf
4796: where paf.assignment_id = p_assignment_id
4797: and paf.grade_id = pgr.grade_or_spinal_point_id
4798: union all
4799: select /*+ ORDERED USE_NL(pgr psp psps pspp)*/

Line 4866: ,per_all_assignments_f paf

4862: (
4863: SELECT '' chk
4864: FROM per_cagr_entitlement_lines_f cagr_lines
4865: ,per_cagr_entitlements cagr_ent
4866: ,per_all_assignments_f paf
4867: WHERE cagr_lines.cagr_entitlement_line_id = p_surrogate_key
4868: AND cagr_ent.cagr_entitlement_id = cagr_lines.cagr_entitlement_id
4869: AND paf.collective_agreement_id = cagr_ent.collective_agreement_id
4870: AND paf.assignment_id = p_assignment_id

Line 6278: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;

6274: and et.effective_end_date;
6275:
6276: -- Local variables declaration.
6277:
6278: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;
6279: l_event_group_id NUMBER ;
6280: l_business_group_id NUMBER ;
6281: l_start_date DATE := p_start_date ;
6282: l_end_date DATE := p_end_date ;

Line 6355: from per_all_assignments_f

6351: if (g_business_group_id is null) then
6352: --cache empty so get now
6353: select max(business_group_id)
6354: into l_business_group_id
6355: from per_all_assignments_f
6356: where assignment_id = p_assignment_id;
6357:
6358: -- There is one exceptional circumstance where bg_id is null
6359: -- specifically, a purge of an asg from per_all_assignments_f

Line 6359: -- specifically, a purge of an asg from per_all_assignments_f

6355: from per_all_assignments_f
6356: where assignment_id = p_assignment_id;
6357:
6358: -- There is one exceptional circumstance where bg_id is null
6359: -- specifically, a purge of an asg from per_all_assignments_f
6360: -- if we care that its been purged then weve caught the event so
6361: -- workaround is to get the bg from ppe
6362: --
6363: if ( l_business_group_id is null) then

Line 6578: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;

6574: ) AS
6575:
6576: -- Local variables declaration.
6577:
6578: l_assignment_id per_all_assignments_f.assignment_id%TYPE ;
6579: l_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE ;
6580: t_dynamic_sql t_dynamic_sql_tab ;
6581: t_proration_dates_temp t_proration_dates_table_type ;
6582: t_proration_change_type_temp t_proration_type_table_type;